https://www.postgresql.org/docs/current/static/auto-explain.html
-Message d'origine-
De : pgsql-performance-ow...@postgresql.org
[mailto:pgsql-performance-ow...@postgresql.org] De la part de Julien Rouhaud
Envoyé : jeudi 28 septembre 2017 11:21
À : Subramaniam C
Cc : pgsql-performance@po
ll check back in a day or two with feedback.
Thanks,
Matt
____
From: Pavy Philippe [philippe.p...@worldline.com]
Sent: Tuesday, March 25, 2014 1:45 PM
To: Ray Stell; Matthew Spilich
Cc: pgsql-performance@postgresql.org
Subject: RE : [PERFORM] Stalls on PGSemaphoreLock
Hello
Hello
Recently I have a similar problem. The first symptom was a freeze of the
connection and 100% of CPU SYS during 2 et 10 minutes, 1 or 2 times per day.
Connection impossible, slow query. The strace on one backend show a very long
system call on semop().
We have a node with 48 cores dans 128
