Re: maintenance_work_mem = 64kB doesn't work for vacuum - Mailing list pgsql-hackers

From David Rowley
Subject Re: maintenance_work_mem = 64kB doesn't work for vacuum
Date
Msg-id CAApHDvpykPiYVueziqMVdUBShhn096uPTo3gTgYZkm-Xth11qw@mail.gmail.com
Whole thread Raw
In response to Re: maintenance_work_mem = 64kB doesn't work for vacuum  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: maintenance_work_mem = 64kB doesn't work for vacuum
List pgsql-hackers
On Mon, 10 Mar 2025 at 10:30, David Rowley <dgrowleyml@gmail.com> wrote:
> Could you do something similar to what's in hash_agg_check_limits()
> where we check we've got at least 1 item before bailing before we've
> used up the all the prescribed memory?  That seems like a safer coding
> practise as if in the future the minimum usage for a DSM segment goes
> above 256KB, the bug comes back again.

FWIW, I had something like the attached in mind.

David

Attachment

pgsql-hackers by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: maintenance_work_mem = 64kB doesn't work for vacuum
Next
From: Erik Wienhold
Date:
Subject: Re: CREATE OR REPLACE MATERIALIZED VIEW