pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
postgresql wait event and high active connection 2+ messages / 2 participants [nested] [flat]
* postgresql wait event and high active connection @ 2021-12-17 07:24 liam saffioti <liam.saffiotti@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: liam saffioti @ 2021-12-17 07:24 UTC (permalink / raw) To: pgsql-admin Hello team, I have a problem with the number of active connections. There are more than 300 active connections in the database currently. When I checked, most connections are waiting as buffer_mapping. (wait_event). This problem happens from time to time, it's not a constant problem. Can you help me figure out why the problem is occurring? I can send you any other information you want about the database. Thank you for your help, Best, Liam ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: postgresql wait event and high active connection @ 2022-01-17 13:36 Halat-Pruvot Sylvie <sylvie.halat-pruvot@ac-toulouse.fr> parent: liam saffioti <liam.saffiotti@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Halat-Pruvot Sylvie @ 2022-01-17 13:36 UTC (permalink / raw) To: liam saffioti <liam.saffiotti@gmail.com>; +Cc: pgsql-admin Hello Liam, I have the same issue with 350 active connexions and have you find a parameter solving this ? Thanks Best regards Sylvie De : liam saffioti <liam.saffiotti@gmail.com> Envoyé : vendredi 17 décembre 2021 08:24 À : pgsql-admin@postgresql.org Objet : postgresql wait event and high active connection Hello team, I have a problem with the number of active connections. There are more than 300 active connections in the database currently. When I checked, most connections are waiting as buffer_mapping. (wait_event). This problem happens from time to time, it's not a constant problem. Can you help me figure out why the problem is occurring? I can send you any other information you want about the database. Thank you for your help, Best, Liam ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2022-01-17 13:36 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2021-12-17 07:24 postgresql wait event and high active connection liam saffioti <liam.saffiotti@gmail.com> 2022-01-17 13:36 ` Halat-Pruvot Sylvie <sylvie.halat-pruvot@ac-toulouse.fr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox