Re: [HACKERS] autovacuum cannot start when connection is full

2006-08-25 Thread ITAGAKI Takahiro
"Guillaume Smet" <[EMAIL PROTECTED]> wrote: > 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 val

Re: [HACKERS] autovacuum cannot start when connection is full

2006-08-24 Thread Guillaume Smet
On 8/25/06, Tom Lane <[EMAIL PROTECTED]> 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/in

Re: [HACKERS] autovacuum cannot start when connection is full

2006-08-24 Thread Tom Lane
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: > Autovacuum uses connections in superuser mode. If all connections are used, > autovacuum cannot start and the following message is written in server log. > | FATAL: sorry, too many clients already > Is this a feature? Yes. I coulda sworn there was

[HACKERS] autovacuum cannot start when connection is full

2006-08-24 Thread ITAGAKI Takahiro
Hi hackers, Autovacuum uses connections in superuser mode. If all connections are used, autovacuum cannot start and the following message is written in server log. | FATAL: sorry, too many clients already Is this a feature? The default value of 'superuser_reserved_connections' is 2, so maybe fe