From: | Muhammad Waqas <waqas(dot)m(at)bitnine(dot)net> |
---|---|
To: | Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Connection exceeded alert. |
Date: | 2024-08-06 05:43:06 |
Message-ID: | CAHYHq4UVF035xUNuoN1w_VXO7VSuUDYipFq7WqWO3X4T1bVVJA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Please check maximum connection / Session parameter in postgreSQL.conf
file and you can increase maximum session/connection.
Please also check locking on database.
2024년 8월 6일 (화) 오전 9:32, Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>님이 작성:
> Hi all,
>
> I have been trying to find a steps or solution for past 1 year once we
> received a connection exceeded alert. Couldn't get any answer from anybody
> or internet so far.
>
> Today I checked a pgbadger report and matched the timeline and found
> that, at that time of sudden connection hike (not normal), there were 3
> queries running at that time (2 update queries on table a , took 5s each,
> one insert query on table b which took 2.5mns).
>
> Anybody provide me steps what all I have to do 1. At that time of
> connection hike 2. If I am been asked to check after sometime as connection
> dropped to analyse.
>
--
*Muhammad Waqas*
*Senior Technical Support Engineer - Tech Support Center (Karachi)*
Mobile: +92-322-2844150
Email: *waqas(dot)m(at)bitnine(dot)net <waqas(dot)m(at)bitnine(dot)net>*
1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem,
DHA Phase 5 Tauheed Commercial Area,
Defense V Defense Housing Authority, Karachi, Karachi City, Sindh,
75500 Pakistan.
From | Date | Subject | |
---|---|---|---|
Next Message | khan Affan | 2024-08-06 06:21:42 | Re: Connection exceeded alert. |
Previous Message | Rajesh Kumar | 2024-08-06 04:32:14 | Connection exceeded alert. |