Re: autovacuum cannot start when connection is full - Mailing list pgsql-hackers

From Guillaume Smet
Subject Re: autovacuum cannot start when connection is full
Date
Msg-id 1d4e0c10608242322mb1a93d8j3db56512892d7f72@mail.gmail.com
Whole thread Raw
In response to Re: autovacuum cannot start when connection is full  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: autovacuum cannot start when connection is full
List pgsql-hackers
On 8/25/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I coulda sworn there was a specific mention in the docs that you'd
> better allow for autovac when choosing superuser_reserved_connections,
> but a quick grep doesn't find it.

There is a mention in autovacuum doc:
http://www.postgresql.org/docs/8.1/interactive/maintenance.html#AUTOVACUUM

Last sentence of the first paragraph is:
"Also, it's important to allow a slot for the autovacuum process when
choosing the value of superuser_reserved_connections."

--
Guillaume


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum cannot start when connection is full
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Intervals within information_schema