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 11:09:37 -0400
Message-ID: <29727.1406732977@sss.pgh.pa.us> (raw)
In-Reply-To: <26640.1406723887@sss.pgh.pa.us>
References: <CAN=gQ4AnP5mQHiU_2YYNDmCps=E3pGXQyAeAQ7RySEURri0V0w@mail.gmail.com>
<CAOR=d=2-NTCiYDAEg+MC4i0S8LJrMUdX2STVufYx_hYKgDHZCA@mail.gmail.com>
<1406707245323-5813258.post@n5.nabble.com>
<26640.1406723887@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-bugs>
I wrote:
> 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 :-(.
Nope, scratch that: I missed the bit before the launcher's main loop,
where it fires off one child and exits if it's launched when autovacuum
is already false.
Still, if it does fire one child process, it looks like that child will
vacuum everything that seems to need vacuuming in the target database.
We should probably adjust that so that tables not in danger of wraparound
get skipped.
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: <29727.1406732977@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