News for hackers. Stuff that matters.
Re:Urban Airship: Postgres to NoSQL and back by zzzeek on Tuesday September 20, 2011 @09:20AM (#3017393)
by far the largest - joins and subqueries actually optimize correctly on Postgresql. In mysql, if you say (pseduosql) "select a_few_rows_from (select many_many_rows from some_table) where <some criterion>", mysql scans "many rows" no matter what. Postgresql can figure out the big picture.

There are no comments on this comment yet.