Re: autovacuum cannot start when connection is full

From: "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "ITAGAKI Takahiro" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: autovacuum cannot start when connection is full
Date: 2006-08-25 06:22:37
Message-ID: 1d4e0c10608242322mb1a93d8j3db56512892d7f72@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 8/25/06, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-08-25 06:34:53 Re: [PATCHES] Intervals within information_schema
Previous Message Tom Lane 2006-08-25 05:37:57 Re: autovacuum cannot start when connection is full