| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | "rjo_roy(at)yahoo(dot)com" <rjo_roy(at)yahoo(dot)com> |
| Cc: | "tgl(at)sss(dot)pgh(dot)pa(dot)us" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Template0 datfrozenxid age is 160million and progressing |
| Date: | 2018-08-01 14:48:24 |
| Message-ID: | CAKJS1f9n9Lf5=P-BuD1QUDGvtEN=VdZxo7O3CJcCa1tfrqedOg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2 August 2018 at 02:31, Rijo Roy <rjo_roy(at)yahoo(dot)com> wrote:
> I agree.. But unfortunately it is the business call and we cannot alter it..
> I am planning to convince them by keeping autovacuum_analyze_threshold to a
> high value so that auto analyse will not kick in very often leaving the
> autovacuum to do its job..
> Please advise.
If autovacuum is disabled, it'll still kick in for any anti-wraparound
work that needs to be performed.
This is also mentioned in the docs:
"Note that even when this parameter is disabled, the system will
launch autovacuum processes if necessary to prevent transaction ID
wraparound. See Section 24.1.5 for more information."
https://www.postgresql.org/docs/10/static/runtime-config-autovacuum.html
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2018-08-01 14:56:04 | Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" . |
| Previous Message | Guillaume Lelarge | 2018-08-01 14:48:08 | Weird behaviour of the planner |