Re: BUG #18141: sorry, too many clients error occurring very frequently

On Fri, Sep 29, 2023 at 7:55 PM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 18141
> Logged by: Ravi Agrawal
> Email address: ravi(dot)s(dot)agrawal23(at)gmail(dot)com
> PostgreSQL version: 13.11
> Operating system: RHEL
> Description:
>
> Hi Team,
>
> We have updated PostgresSQL from version 13.4 to 13.11 and observing
> 'sorry,
> too many clients' error very frequently.
> Connection count is shooting up on performing basic operations and
> crossing
> the max_connections value. This has not been observed previously on
> Postgres
> v13.4
> We need to understand if this issue is caused due to the change in version.
> Is there any history of known incidents facing this issue with the specific
> version of PostgreSQL.
>

I think it is unlikely to be a bug. How did you do the upgrade? Just
install the new binaries, then restart the server?

Can you capture plans from the newly slow queries and compare them to plans
from the same queries before the upgrade?

Cheers,

Jeff