Advertising

Aside from the config issues Chris mentioned, I'd recommend trying
a somewhat less obsolete version of Postgres. I believe the poor
performance with grouped aggregates should be fixed in 7.4 and later.
(Red Hat 7.2 is a bit long in the tooth as well.)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster