Re: Mysterious performance degradation in exceptional cases - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Mysterious performance degradation in exceptional cases
Date
Msg-id d33257f7-ee04-bfa2-6546-c78b8e5f3440@aklaver.com
Whole thread Raw
In response to Re: Mysterious performance degradation in exceptional cases  (Matthias Apitz <guru@unixarea.de>)
List pgsql-general
On 9/18/22 09:36, Matthias Apitz wrote:

>> You can load auto_explain per session as shown here:
> 
> Every connect from the ILL forks a new 'app-server' session which
> creates a new ESQL/C session, and all this occur randomly when the ILL
> wants to search for a book title if this is available in that library.
> In short: no way.

How is it random?

Are you saying that the ESQL/C session does not 'know' the search is 
coming from the ILL connection?

> 
> Thanks
> 
>     matthias
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com



pgsql-general by date:

Previous
From: Matthias Apitz
Date:
Subject: Re: Mysterious performance degradation in exceptional cases
Next
From: celati Laurent
Date:
Subject: Fwd: Postgresql/Postgis: Trigger for historization/versioning