pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTransaction ID's and Vacuum
2+ messages / 2 participants
[nested] [flat]
* Transaction ID's and Vacuum
@ 2010-11-11 00:18 Samuel Stearns <SStearns@internode.com.au>
0 siblings, 1 reply; 2+ messages in thread
From: Samuel Stearns @ 2010-11-11 00:18 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Transaction ID's and Vacuum
@ 2010-11-11 00:46 Tom Lane <tgl@sss.pgh.pa.us>
parent: Samuel Stearns <SStearns@internode.com.au>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2010-11-11 00:46 UTC (permalink / raw)
To: Samuel Stearns <SStearns@internode.com.au>; +Cc: pgsql-admin
Samuel Stearns <SStearns@internode.com.au> writes:
> 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?
No. There is no need to worry. The transaction counter will march up
to 4 billion and then wrap around, if you keep the instance going that
long. This is not a problem.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2010-11-11 00:46 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-11-11 00:18 Transaction ID's and Vacuum Samuel Stearns <SStearns@internode.com.au>
2010-11-11 00:46 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox