Postgres Pro
Downloads
Home   >   mailing lists

Transaction ID's and Vacuum - Mailing list pgsql-admin

From Samuel Stearns
Subject Transaction ID's and Vacuum
Date
Msg-id 68B59BEDCD36854AADBDF17E91B2937A0783A723F8@EXCHMAIL.staff.internode.com.au
Whole thread Raw
Responses Re: Transaction ID's and Vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

Howdy,

 

I’ve got an old 7.4.5 instance of Postgres running on Linux.  My transaction ID’s are just over the 1 billion mark.  I ran an instance wide vacuum analyse but this had now effect on the transaction ID count.  Do I need to run a vacuum full?

 

Thanks,

 

Sam

pgsql-admin by date:

Previous
From: Isabella Ghiurea
Date:
Subject: Re: PG HA solution using DBRD
Next
From: Tom Lane
Date:
Subject: Re: Transaction ID's and Vacuum