From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Jerry Sievers <gsievers19(at)comcast(dot)net> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Does raising maintenance_work_mem get seen by an already running aucovac? |
Date: | 2023-01-25 21:36:03 |
Message-ID: | 2845694.1674682563@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Jerry Sievers <gsievers19(at)comcast(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jerry Sievers | 2023-01-25 23:28:00 | Re: Does raising maintenance_work_mem get seen by an already running aucovac? |
Previous Message | Ron | 2023-01-25 18:02:29 | Re: Long running queries |