Re: work_mem greater than 2GB issue

Quoting wickro <robwickert(at)gmail(dot)com>:
> 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.html

I'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