KNN indexing!
PostgreSQL 9.1 released
11–20 of 47 posts
Re: PostgreSQL 9.1 released
#12I recently switched to PostgreSQL from MySQL and I couldn't be happier about it.
It seems that in general this decision should be made more frequently than it is, at least for new projects. Why do not more people select Postgres? Is it comfort level with MySQL? Tools and extensions?
Re: PostgreSQL 9.1 released
#13KNN indexing!
Can anyone give an example use case for this? I'm not sure I fully understand what it means.
Re: PostgreSQL 9.1 released
#14KNN indexing!
Can anyone give an example use case for this? I'm not sure I fully understand what it means.
In spatial queries, find the 5 restaurants closest to me. In full text search, find the 5 words closest to "fuschia" so you can spell check, or try to search for what you __think__ the user meant to type.
Re: PostgreSQL 9.1 released
#15KNN indexing!
Can anyone give an example use case for this? I'm not sure I fully understand what it means.
Here's the presentation from last year's PGCon, it's not exactly easy to follow, but has some hints on how this can be used:
Re: PostgreSQL 9.1 released
#16I recently switched to PostgreSQL from MySQL and I couldn't be happier about it.
It seems that in general this decision should be made more frequently than it is, at least for new projects. Why do not more people select Postgres? Is it comfort level with MySQL? Tools and extensions?
It may be that tutorials for Tool X use MySQL in their examples.
Re: PostgreSQL 9.1 released
#17I recently switched to PostgreSQL from MySQL and I couldn't be happier about it.
It seems that in general this decision should be made more frequently than it is, at least for new projects. Why do not more people select Postgres? Is it comfort level with MySQL? Tools and extensions?
Nearly all of the introductory PHP tutorials use MySQL, so many beginning web developers automatically go to MySQL because it is the only thing they have played around with.
Re: PostgreSQL 9.1 released
#18I recently switched to PostgreSQL from MySQL and I couldn't be happier about it.
It seems that in general this decision should be made more frequently than it is, at least for new projects. Why do not more people select Postgres? Is it comfort level with MySQL? Tools and extensions?
> Why do not more people select Postgres? Is it comfort level with MySQL?
* Cheap (let alone free/ISP) hosting does not provide Postgres
* Most introductory tutorials, especially in the PHP world (but also Ruby I believe) use MySQL
* AMP packages/installers (is there any out there using Postgres as its db?) and a history of punitively hard installation
Following that, a combination of habit (MySQL works for me, why would I care?) and BLUB (what could it even bring to the table?), as well as drawbacks/issues whose fixes are recent (replication, master/slave, ...)
Re: PostgreSQL 9.1 released
#19Congrats to the team for a really exciting release. We can't wait to ship it here at Heroku.