News for hackers. Stuff that matters.
Re:Everybody thinks SQL joins are slow-is it because MySQL d... by johnzabroski on Friday June 17, 2011 @04:27PM (#2666948)
Aggregates that have to do full table scans are notoriously slow in Postgres due to how multi-version concurrency control is implemented.

Any time you comment out a WHERE clause on a big table while performing an aggregate report, Postgres chokes.

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.