Neil Conway <neilc@xxxxxxxxxxx> writes: > Have you run ANALYZE recently? You might be running into the well-known > problem that hashed aggregation can consume an arbitrary amount of > memory -- posting the EXPLAIN for the query would confirm that. It would be useful to confirm whether this behavior is any different from 8.0 ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
