From: | github kran <githubkran(at)gmail(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | AutoVacuum and growing transaction XID's |
Date: | 2020-05-07 18:23:04 |
Message-ID: | CACaZr5SqNicN0YN2A12-Vt3bStxxQhi0ieE0yvNx=3d12JAQKg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
Hello Team,
We are using a PostgreSQL version -9.6.12 version and from last 4 weeks our
Transaction ID's (XID's) have increased by 195 million to 341 million
transactions. I see the below from pg_stat_activity from the postGreSQL DB.
1) Viewing the pg_stat-activity I noticed that the vacuum query is
running for a runtime interval of few hours to 3-5 days whenever I check
the pg_stat-activity. Is this a common process postgreSQL runs ? I have
noticed this running and show in the pg_stat activity from last few weeks
only. Also the query shows the table name with
(to prevent wrap around) for each of the tables in the vacuum query as
output. What does this mean ?
2) Does it mean I need to run a manual auto vacuum process for these
tables ? as the transaction ids have increased from 195 million to 341
million ?.
What other things I need to check in the database around this ?.
Thanks !!
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Lewis | 2020-05-07 18:32:32 | Re: AutoVacuum and growing transaction XID's |
Previous Message | Julien Rouhaud | 2020-05-07 18:22:00 | Re: increase of xact_commit vs txid_current |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Lewis | 2020-05-07 18:32:32 | Re: AutoVacuum and growing transaction XID's |
Previous Message | Amarendra Konda | 2020-05-07 18:07:42 | Re: Explain plan changes - IN CLAUSE ( Passing direct values Vs INNER Query ) |