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