From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: vacuumdb idle processes |
Date: | 2021-06-11 18:33:49 |
Message-ID: | 1972046.1623436429@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> writes:
> I have done a setup to run vacuumdb with 8 parallel jobs daily. It has been
> running quite well.
Apparently not all that well, if it failed to keep us out of an
autovacuum-to-prevent-wraparound situation. I suppose you had autovacuum
disabled because you thought this lashup was sufficient?
> Just today I saw there is an aggressive autovacuum process running(to
> prevent wraparound) on one of the table. vacuumdb which started later
> spawned the 8 connections. One connection (doing vacuum on the table on
> which an aggressive autovacuum is running) is waiting for "autovacuum(to
> prevent wraparound)" to complete while the other 7 connections are just
> sitting idle.
> I am okay that one connection is waiting since an aggressive autovacuum is
> running on that table but how come other connections have not released the
> sesion yet? Any reason for this?
Perhaps this is the last remaining table so vacuumdb has nothing
else for them to do.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Nikhil Shetty | 2021-06-12 07:04:38 | Re: vacuumdb idle processes |
Previous Message | Nikhil Shetty | 2021-06-11 17:58:23 | vacuumdb idle processes |