From: Jerry Sievers <gsievers19@comcast.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Does raising maintenance_work_mem get seen by an already running aucovac?
Date: Wed, 25 Jan 2023 17:28:00 -0600
Message-ID: <m0r0vichz3.fsf@comcast.net> (raw)
In-Reply-To: <2845694.1674682563@sss.pgh.pa.us>
References: <m0y1pqcxl9.fsf@comcast.net>
<2845694.1674682563@sss.pgh.pa.us>
Tom Lane <tgl@sss.pgh.pa.us> writes:
> Jerry Sievers <gsievers19@comcast.net> writes:
>
>> There's a long running anti-wrap autovac that we'd rather let finish but
>> on the server instance, I found maintenance_work_mem rather low and thus
>> raised it in postgresql.comf, reloaded and confirmed that my interactive
>> session saw the change.
>
>> Can a running autovac make use of this or should I either wait it out or
>> cancel and let it restart when ready?
>
> Looks like an autovac worker will notice postgresql.conf changes once
> per table:
>
> /*
> * Perform operations on collected tables.
> */
> foreach(cell, table_oids)
> {
> ...
>
> /*
> * Check for config changes before processing each collected table.
> */
> if (ConfigReloadPending)
> ProcessConfigFile(PGC_SIGHUP);
>
> If it is stuck on a particularly enormous table, you might be best off
> to kill it, but otherwise I'd let it go.
>
> regards, tom lane
Thanks Tom!
That's the situation, the >1TB table is just chugging along.
So, a live individual vacuum of a particulart table will not start using
more mwm but later tasks will.
In fact, the existing setting which I believed too small probably does
exceed the 1G limit of some kind that's explained in the docs and ps
shows that process having about 1G of memory allocated, so perhaps the
frobbling wasn't too useful a fix.
Ack'd
I'll keep an eye on things.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, tgl@sss.pgh.pa.us, pgsql-admin@lists.postgresql.org
Subject: Re: Does raising maintenance_work_mem get seen by an already running aucovac?
In-Reply-To: <m0r0vichz3.fsf@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox