Re: Mysterious performance degradation in exceptional cases

2022-10-21 Thread Laurenz Albe
On Fri, 2022-10-21 at 09:48 +0200, Matthias Apitz wrote: > > all this should not take longer than 1-2 seconds, and > > normally it does not take longer. But, in some situations it takes > > longer than 180 seconds, in 10% of the cases. > > DBCEXIT|N|sisisinst|RDIR|4|21.10.2022 06:08:25:594 > DBCEX

Re: Mysterious performance degradation in exceptional cases

2022-10-21 Thread Matthias Apitz
El día Mittwoch, September 14, 2022 a las 10:31:26 +0200, Matthias Apitz escribió: > > We have a C-written application server which uses ESQL/C on top > of PostgreSQL 13.1 on Linux. The application in question always serves > the same search in a librarian database, given to the server > as comm

Re: Mysterious performance degradation in exceptional cases

2022-09-18 Thread Adrian Klaver
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 li

Re: Mysterious performance degradation in exceptional cases

2022-09-18 Thread Matthias Apitz
El día domingo, septiembre 18, 2022 a las 07:47:32a. m. -0700, Adrian Klaver escribió: > On 9/18/22 02:30, Matthias Apitz wrote: > > El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver > > escribió: > > > > > On 9/14/22 22:33, Matthias Apitz wrote: > > > > El día miércol

Re: Mysterious performance degradation in exceptional cases

2022-09-18 Thread Adrian Klaver
On 9/18/22 02:30, Matthias Apitz wrote: El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver escribió: On 9/14/22 22:33, Matthias Apitz wrote: El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian Klaver escribió: On 9/14/22 01:31, Matthias Apitz wr

Re: Mysterious performance degradation in exceptional cases

2022-09-18 Thread Matthias Apitz
El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver escribió: > On 9/14/22 22:33, Matthias Apitz wrote: > > El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian > > Klaver escribió: > > > > > On 9/14/22 01:31, Matthias Apitz wrote: > > > > Where is th

Re: Mysterious performance degradation in exceptional cases

2022-09-15 Thread Adrian Klaver
On 9/14/22 22:33, Matthias Apitz wrote: El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian Klaver escribió: On 9/14/22 01:31, Matthias Apitz wrote: Where is the inter library software, in your application or are you reaching out to another application? The above 'app-

Re: Mysterious performance degradation in exceptional cases

2022-09-14 Thread Matthias Apitz
El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian Klaver escribió: > On 9/14/22 01:31, Matthias Apitz wrote: > > > > We have a C-written application server which uses ESQL/C on top > > of PostgreSQL 13.1 on Linux. The application in question always serves > > the same searc

Re: Mysterious performance degradation in exceptional cases

2022-09-14 Thread Tom Lane
Matthias Apitz writes: > To fulfill the search, the application server has to do some 100 > ESQL/C calls and all this should not take longer than 1-2 seconds, and > normally it does not take longer. But, in some situations it takes > longer than 180 seconds, in 10% of the cases. The other 90% are

Re: Mysterious performance degradation in exceptional cases

2022-09-14 Thread Adrian Klaver
On 9/14/22 01:31, Matthias Apitz wrote: We have a C-written application server which uses ESQL/C on top of PostgreSQL 13.1 on Linux. The application in question always serves the same search in a librarian database, given to the server as commands over the network, login into the application and

Mysterious performance degradation in exceptional cases

2022-09-14 Thread Matthias Apitz
We have a C-written application server which uses ESQL/C on top of PostgreSQL 13.1 on Linux. The application in question always serves the same search in a librarian database, given to the server as commands over the network, login into the application and doing a search: SLNPServerInit User:zfl