Silvio Brandani <silvio.brandani@tech.sdb.it> writes:
>> "Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>>> What query?
[ query with aggregates and GROUP BY ]
Does EXPLAIN show that it's trying to use a hash aggregation plan?
If so, try turning off enable_hashagg. I think the hash table might
be ballooning far past the number of entries the planner expected.
Do you have an idea how many groups there should be in the query
result?
regards, tom lane