Re: Help understanding server-side logging (and more...)

2023-12-21 Thread Adrian Klaver
On 12/21/23 03:05, Dominique Devienne wrote: If by any chance, anyone has seen this kind of behavior before, in a similar context or not, and has suggestions on how we could further troubleshoot this (on the PostgreSQL server-side, but also the Node.JS client-side, why not), that would be grea

Re: Help understanding server-side logging (and more...)

2023-12-21 Thread Peter J. Holzer
On 2023-12-21 12:05:41 +0100, Dominique Devienne wrote: > FWIW, the symptoms they are experiencing is that initially all queries > are fast, then they start to get longer and longer, to the point all > services accessing PostgreSQL grind to a halt and basically hang. > While that happens, one can c

Re: Help understanding server-side logging (and more...)

2023-12-21 Thread Julien Rouhaud
Hi, On Thu, Dec 21, 2023 at 12:05:41PM +0100, Dominique Devienne wrote: > Hi. Another team (than mine) has been trying to troubleshoot hang issues in > their Node/JS/TS-based mid-tier services, > after a switch from MySQL to PostgreSQL. They run PostgreSQL in a Linux > container (see PID [1] below

Help understanding server-side logging (and more...)

2023-12-21 Thread Dominique Devienne
Hi. Another team (than mine) has been trying to troubleshoot hang issues in their Node/JS/TS-based mid-tier services, after a switch from MySQL to PostgreSQL. They run PostgreSQL in a Linux container (see PID [1] below), unlike us. They started looking at the PostgreSQL server-side logs, but with l