Martijn van Oosterhout wrote:
On Mon, Nov 27, 2006 at 02:22:19PM -0600, Tony Caduto wrote:
Just in case anyone is interested I did get it up and running with no
damage to the system.
It took well over a year for it to reach the 1 million threshold mark.
You mean one *billion*, right?
That's one busy server!
Hopeefully you've updated your maintainence setup to avoid this in the
future?
Have a nice day,
The server stops accepting requests when it is 1 million transactions
away from hitting 1 billion.
That's what I meant by the 1 million threshold :-)
I did not have autovacuum turned on and I usually do a vacuumdb -z -a -f
-q each night but this one slipped through the cracks :-(
Later,
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
