Quoting wickro <robwickert@xxxxxxxxx>:
I have a largish table (> 8GB). I'm doing a very simple single group by on.
This doesn't answer your question, but you might want to take advantage of table partitioning:
http://www.postgresql.org/docs/8.3/interactive/ddl-partitioning.htmlI've recently gone through this exercise (several tables were 10GB+, some almost 30GB) and if your WHERE clauses qualify, then expect significant performance gains with /much/ better memory consumption.
You only have one large table, so partitioning it should be painless and not take too long (unlike our scenario).
Cheers Henry
Attachment:
pgpQ5N5Rdos2c.pgp
Description: PGP Digital Signature
