| From: | Michael Lewis <mlewis(at)entrata(dot)com> |
|---|---|
| To: | github kran <githubkran(at)gmail(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>, Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: AutoVacuum and growing transaction XID's |
| Date: | 2020-05-07 18:32:32 |
| Message-ID: | CAHOFxGok4H++SHLq50v8wp5FmnTe-9+EzJs9jS7uAT68XBOKZA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
It is trying to do a vacuum freeze. Do you have autovacuum turned off? Any
settings changed from default related to autovacuum?
https://www.postgresql.org/docs/9.6/routine-vacuuming.html
Read 24.1.5. Preventing Transaction ID Wraparound Failures
These may also be of help-
https://info.crunchydata.com/blog/managing-transaction-id-wraparound-in-postgresql
https://www.2ndquadrant.com/en/blog/managing-freezing/
Note that you need to ensure the server gets caught up, or you risk being
locked out to prevent data corruption.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amarendra Konda | 2020-05-07 18:51:45 | Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) |
| Previous Message | github kran | 2020-05-07 18:23:04 | AutoVacuum and growing transaction XID's |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amarendra Konda | 2020-05-07 18:51:45 | Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) |
| Previous Message | github kran | 2020-05-07 18:23:04 | AutoVacuum and growing transaction XID's |