On Fri, 2003-10-03 at 21:39, Bruce Momjian wrote: > I have updated the FAQ to be: > > In comparison to MySQL or leaner database systems, we are > faster for multiple users, complex queries, and a read/write query > load. MySQL is faster for SELECT queries done by a few users. > > Is this accurate? It seems so.
May wish to say ... for simple SELECT queries ... Several left outer joins, subselects and a large number of joins are regularly performed faster in PostgreSQL due to a more mature optimizer. But MySQL can pump out SELECT * FROM table WHERE key = value; queries in a hurry. I've often wondered if they win on those because they have a lighter weight parser / optimizer with less "lets try simplifying this query" steps or if the MYISAM storage mechanism is simply quicker at pulling data off the disk.
signature.asc
Description: This is a digitally signed message part