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

From ITAGAKI Takahiro
Subject Re: autovacuum cannot start when connection is full
Date
Msg-id 20060825174243.55E5.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
In response to Re: autovacuum cannot start when connection is full  ("Guillaume Smet" <guillaume.smet@gmail.com>)
List pgsql-hackers
"Guillaume Smet" <guillaume.smet@gmail.com> 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 value of superuser_reserved_connections."

Thank you!

It may be as well to add the same mention to the description of
superuser_reserved_connections.
| Determines the number of connection "slots" that are reserved for connections
| by PostgreSQL superusers, *including autovacuum*.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: Böszörményi Zoltán
Date:
Subject: Performance testing of COPY (SELECT) TO
Next
From: Gregory Stark
Date:
Subject: Re: Tricky bugs in concurrent index build