| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Perumal Raj <perucinci(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Autovacuum Transaction Wraparound |
| Date: | 2019-03-11 19:07:14 |
| Message-ID: | 1c659890-cbf7-8c6d-266c-7521ab674bbf@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3/11/19 11:51 AM, Perumal Raj wrote:
> Hi Experts
>
> I have noticed in my Database that, there is no regular Vacuum
> maintenance happening
What Postgres version?
> So i started Weekly Job across cluster. But still i am seeing gradual
> growth on transacation ID.
What query are you using?
>
> DB is still using default autovacuum_freeze_min_age &
> autovacuum_freeze_table_age.
What are the actual settings for?:
https://www.postgresql.org/docs/10/runtime-config-autovacuum.html
>
> Question : Since i am running regularly vacuum job ( weekly) and the
> Transaction age is gradually growing , What is next once i hit 200M
> limit ( default ).
> Should i increase my default value ? If so any calculation for increase
> the value based on my DB transaction growth.
>
> Thanks,
> Raj
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Perumal Raj | 2019-03-11 19:16:23 | Re: Autovacuum Transaction Wraparound |
| Previous Message | Perumal Raj | 2019-03-11 18:51:50 | Autovacuum Transaction Wraparound |