| From: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | vacuumdb idle processes |
| Date: | 2021-06-11 17:58:23 |
| Message-ID: | CAFpL5Vyb4dx=nqBZ_GB1M_TxA-3+E-bSav3fDQnVHW2udXEV5g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
I have done a setup to run vacuumdb with 8 parallel jobs daily. It has been
running quite well.
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?
Thanks,
Nikhil
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-06-11 18:33:49 | Re: vacuumdb idle processes |
| Previous Message | Vineet Naik | 2021-06-11 15:05:20 | Re: Autovacuum or manual vacuum to recover from XID wraparound? |