Should autovacuum do a database wide vacuum near transaction limit? - Mailing list pgsql-admin

From John Lister
Subject Should autovacuum do a database wide vacuum near transaction limit?
Date
Msg-id 927BF3A3F54247FF8C63219A00CE98B5@squarepi.com
Whole thread Raw
Responses Re: Should autovacuum do a database wide vacuum near transaction limit?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,  I'm running 8.3.9 on ubuntu with autovacuum enabled and seemingly working properly., however I've started getting messages saying that I'm near the transaction limit and I need to do a database wide vacuum, which I've started.

From reading the docs, though I thought that autovacuum would do this on my behalf, is this true? I would have expected it to run before I started getting warnings, or does it wait until the warnings start? If not, is there any config setting or other reason why autovacuum isn't doing a database wide vacuum as expected or do I always need to do a manual one?

Thanks

John
--
 
Got needs? Get Goblin'! - http://www.pricegoblin.co.uk/

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql question
Next
From: Tom Lane
Date:
Subject: Re: Should autovacuum do a database wide vacuum near transaction limit?