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

From Tom Lane
Subject Re: autovacuum cannot start when connection is full
Date
Msg-id 19307.1156484277@sss.pgh.pa.us
Whole thread Raw
In response to autovacuum cannot start when connection is full  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: autovacuum cannot start when connection is full
List pgsql-hackers
ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.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


pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: autovacuum cannot start when connection is full
Next
From: "Guillaume Smet"
Date:
Subject: Re: autovacuum cannot start when connection is full