Re: autovacuum cannot start when connection is full

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: autovacuum cannot start when connection is full
Date: 2006-08-25 05:37:57
Message-ID: 19307.1156484277@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> 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 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.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guillaume Smet 2006-08-25 06:22:37 Re: autovacuum cannot start when connection is full
Previous Message ITAGAKI Takahiro 2006-08-25 05:22:03 autovacuum cannot start when connection is full