From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: [ADMIN] Can postgres run autovacuum tasks when autovacuum is disabled? |
Date: | 2014-07-30 15:09:37 |
Message-ID: | 29727.1406732977@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrey Zhidenkov | 2014-07-31 05:56:13 | Re: [ADMIN] Can postgres run autovacuum tasks when autovacuum is disabled? |
Previous Message | Tom Lane | 2014-07-30 12:38:07 | Re: [ADMIN] Can postgres run autovacuum tasks when autovacuum is disabled? |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Nelson | 2014-07-30 15:33:14 | extract('epoch' from age()) returning wrong number of seconds |
Previous Message | Bruce Momjian | 2014-07-30 14:58:03 | Re: BUG #11090: Unclear error message in pg_upgrade |