Re: autovacuum cannot start when connection is full

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Re: autovacuum cannot start when connection is full
Дата
Msg-id 20060825174243.55E5.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: autovacuum cannot start when connection is full  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Böszörményi Zoltán
Дата:
Сообщение: Performance testing of COPY (SELECT) TO
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Tricky bugs in concurrent index build