Came across a blog from Ovid, one of the Perl gurus at BBC.
"They're not kidding, either. Subquery optimization in MySQL is terribly
as we've discovered today. We have Matt Trout in for some consulting and
even ridiculously stupid subqueries have terrible query plans, forcing us to
to consider nasty workarounds, one of which is called "PostgreSQL"."
Even though he counts PostgreSQL as one of th enasty workarounds, maybe we
should give them a helping hand?
pgsql-advocacy by date
|Next:||From: Andreas 'ads' Scherbaum||Date: 2008-02-27 14:12:39|
|Subject: Re: pg_live situation update|
|Previous:||From: Magnus Hagander||Date: 2008-02-25 16:21:07|
|Subject: Re: Report FOSDEM (Brussels) 2008|
pgsql-general by date
|Next:||From: Andrus||Date: 2008-02-25 19:47:58|
|Subject: Re: Use index for upper(customername) like 'ABC%'|
|Previous:||From: Tom Lane||Date: 2008-02-25 19:17:33|
|Subject: Re: text and bytea |