AutoVacuum and growing transaction XID's

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 !!

Responses

Browse pgsql-general by date

  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

Browse pgsql-performance by date

  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 )