Re: Mysterious performance degradation in exceptional cases

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Matthias Apitz <guru(at)unixarea(dot)de>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Mysterious performance degradation in exceptional cases
Date: 2022-09-18 17:05:37
Message-ID: d33257f7-ee04-bfa2-6546-c78b8e5f3440@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message celati Laurent 2022-09-18 19:26:22 Fwd: Postgresql/Postgis: Trigger for historization/versioning
Previous Message Matthias Apitz 2022-09-18 16:36:39 Re: Mysterious performance degradation in exceptional cases