Re:Everybody thinks SQL joins are slow-is it because MySQL d...
by gtuhl on Friday June 17, 2011 @04:39PM
(#2666988)
Compared to MyISAM? Sure for certain aggregate functions, but it's too easy to point out reasons for avoiding MyISAM: fragmentation, no transactions, table locks on writes, complete table rewrites to change columns or indexes, only scales up to about 8 cores.
Compared to InnoDB? You are incorrect, Postgres is faster, even for a raw count(*), even when comparing against the InnoDB plugin and not the ancient InnoDB builtin.
I have access to tuned TB+ DBs of both types and am happy to disprove any specific examples you can provide.
Re:Everybody thinks SQL joins are slow-is it because MySQL d...
by johnzabroski on Friday June 17, 2011 @05:04PM
(#2667068)
I just read up on this and it appears you are right, my issues are fixed in more recent versions of PostgreSQL. Apologies.
Any time you comment out a WHERE clause on a big table while performing an aggregate report, Postgres chokes.