| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "rjo_roy(at)yahoo(dot)com" <rjo_roy(at)yahoo(dot)com>, "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 15:39:37 |
| Message-ID: | 20180801153937.clg7zzc2mqle5z2l@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
On 2018-08-01 10:24:24 -0400, Tom Lane wrote:
> Rijo Roy <rjo_roy(at)yahoo(dot)com> writes:
> > Thanks for the advice. Autovacuum is disabled in the environment and I cannot take a call on enabling it back. I can only run manual vacuum on the database as the dev team fears autoanalyze changing the query performance. Do you still think we don't need to take any actions.
>
> IMO, the action you need to take is enabling autovacuum. We've
> seen many many people go down the path you are taking, and it's
> generally led to no good in the end. Manual vacuuming tends
> to miss stuff, and it cannot react adequately to activity spikes.
But it shouldn't matter here, autovacuum will start regardless, no?
Greetings,
Andres Freund
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-08-01 16:07:16 | Re: Template0 datfrozenxid age is 160million and progressing |
| Previous Message | Tom Lane | 2018-08-01 15:12:27 | Re: ALTER ROLE SET search_path produced by pg_dumpall gives : ERROR: syntax error at or near "$" . |