Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Re: autovacuum cannot start when connection is full


  • From: ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>
  • To: "Guillaume Smet" <guillaume.smet@gmail.com>
  • Cc: "Tom Lane" <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
  • Subject: Re: autovacuum cannot start when connection is full
  • Date: Fri, 25 Aug 2006 17:51:10 +0900
  • Message-id: <20060825174243.55E5.ITAGAKI.TAKAHIRO@oss.ntt.co.jp>

"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





Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group