From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | ravi(dot)s(dot)agrawal23(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #18141: sorry, too many clients error occurring very frequently |
Date: | 2023-09-29 18:12:19 |
Message-ID: | d077a843-d9a7-59f6-b3ef-97068ce19ae3@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On 9/29/23 10:31, PG Bug reporting form wrote:
> 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.
Question -- are you using pg_stat_statements? If so, please try
disabling it and see if the issue goes away. Also was is your work_mem
setting? Does raising it help?
--
Joe Conway
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2023-09-29 18:15:49 | Re: BUG #18137: PG16 release note doc bug in "Allow GRANT group_name TO user_name ..." |
Previous Message | Wetmore, Matthew (CTR) | 2023-09-29 18:12:15 | BUG #18141: sorry, too many clients error occurring very frequently |