Matthias Apitz <guru@xxxxxxxxxxx> 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 below 2 seconds, > i.e. this is digital: Or 2 seconds, or more than 180 seconds, no values between. I'm wondering about a plan change. Can you install auto_explain on the server and capture info about the fast and slow cases? regards, tom lane
