Tony Caduto wrote: > 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 :-(
Strange -- autovacuum should have started an automatic database-wide vacuum on that database, even if disabled. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
