Silvio Brandani <silvio.brandani@xxxxxxxxxxx> writes: >> "Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
