On Mon, Nov 29, 2021 at 02:01:35PM +0000, Arne Roland wrote:
> But my main goal is something else. I can't explain my clients, why a chanced statistics due to autovacuum suddenly leads to oom. They would be right to question postgres qualification for any serious production system.
What version postgres was that on ?
I realize it doesn't address your question, but since PG13, HashAggregate
respects work_mem. Depending on the details of the query plan, that's arguably
a bigger problem than the absence of a global work_mem. At least that one is
resolved.
--
Justin