| From: | Rijo Roy <rjo_roy(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Extremely slow autovacuum:vacuum to prevent wraparound |
| Date: | 2018-07-11 11:33:40 |
| Message-ID: | 1734155292.2575738.1531308820197@mail.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi Experts,
I am running a PG10.4 in a RHEL 6.9. The tables stored in my database are mainly used for reads and very less writes happen. I have recently joined this environment and as soon as I logged into the postgresql servers, checked for dead tuples and relfrozenids.. And almost all have reached the autovacuum_freeze_max_age of 2billion and autovacuum was disabled.. Last vacuum was run 3 months back. Today I got permission to vacuum the tables but for 3 tables, Postgresql has already started the vacuum freeze using the autovacuum daemon running to prevent wraparound and these tables have TB'S of data.Experts, please confirm whether I can kill these sessions and run a manual vacuum job with parallel jobs.
Thanks in advance.
Regards, Rijo Roy
Sent from Yahoo Mail on Android
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rijo Roy | 2018-07-11 12:17:13 | Re: Extremely slow autovacuum:vacuum to prevent wraparound |
| Previous Message | Raymond O'Donnell | 2018-07-11 09:51:21 | Re: Open Source tool to deploy/promote PostgreSQL DDL |