From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G Johnston <david.g.johnston@gmail.com>
Cc: pgsql-admin@postgresql.org
Cc: pgsql-bugs@postgresql.org
Subject: Re: [ADMIN] Can postgres run autovacuum tasks when autovacuum is disabled?
Date: Wed, 30 Jul 2014 08:38:07 -0400
Message-ID: <26640.1406723887@sss.pgh.pa.us> (raw)
In-Reply-To: <1406707245323-5813258.post@n5.nabble.com>
References: <CAN=gQ4AnP5mQHiU_2YYNDmCps=E3pGXQyAeAQ7RySEURri0V0w@mail.gmail.com>
<CAOR=d=2-NTCiYDAEg+MC4i0S8LJrMUdX2STVufYx_hYKgDHZCA@mail.gmail.com>
<1406707245323-5813258.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
David G Johnston <david.g.johnston@gmail.com> writes:
> Scott Marlowe-2 wrote
>> Are you sure these aren't to prevent wrap-around?
> This is my other theory, and probably the correct one. Is this something
> that can be discovered from the logs (since nothing in the query provides
> this detail)?
In all recent versions of Postgres, the pg_stat_activity line should
include "(to prevent wraparound)" if that's what autovac thinks it's
doing.
However ... it looks to me like if the autovac launcher gets launched
forcibly because of a possible wraparound issue, it will keep running
normally after that even if autovacuum is off :-(. You need to SIGHUP
it to get it to quit again. (A second bug is that it will then honor the
SIGHUP and quit, even if the wraparound emergency is still present.)
So I'm betting that what happened, particularly given the OP's apparent
insistence on managing vacuums manually, is that a wraparound vacuum
was forced on some relatively small table and then the launcher kept
doing its thing after that. Since log_autovacuum_min_duration was
set to 0, there should be some evidence for this theory in the logs
(although it looks like the log entries *don't* say whether the
vacuum was for wraparound :-().
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
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: tgl@sss.pgh.pa.us, david.g.johnston@gmail.com, pgsql-bugs@postgresql.org
Subject: Re: [ADMIN] Can postgres run autovacuum tasks when autovacuum is disabled?
In-Reply-To: <26640.1406723887@sss.pgh.pa.us>
* 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