Neil Conway <neilc(at)samurai(dot)com> 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