Re: [GENERAL] Function runtime increases after 5 calls in the same session.

2014-10-22 Thread Ilya Ashchepkov
Tom Lane Wrote in message: > Marti Raudsepp writes: >> On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov >> wrote: >>> I wrote a function and during testing it I came across the strange >>> behaviour. >>> Function runtime is about 200ms first 5 times, 6th and futher calls takes >>> ~22000 ms

Re: [GENERAL] Function runtime increases after 5 calls in the same session.

2014-10-21 Thread Tom Lane
Marti Raudsepp writes: > On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov wrote: >> I wrote a function and during testing it I came across the strange >> behaviour. >> Function runtime is about 200ms first 5 times, 6th and futher calls takes >> ~22000 ms. >> I simplified my schema, you can se

Re: [GENERAL] Function runtime increases after 5 calls in the same session.

2014-10-21 Thread Ilya Ashchepkov
Marti Raudsepp Wrote in message: > Hi > > On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov wrote: >> I wrote a function and during testing it I came across the strange >> behaviour. >> Function runtime is about 200ms first 5 times, 6th and futher calls takes >> ~22000 ms. >> I simplified my

Re: [GENERAL] Function runtime increases after 5 calls in the same session.

2014-10-21 Thread Marti Raudsepp
Hi On Tue, Oct 21, 2014 at 12:53 PM, Ilya I. Ashchepkov wrote: > I wrote a function and during testing it I came across the strange > behaviour. > Function runtime is about 200ms first 5 times, 6th and futher calls takes > ~22000 ms. > I simplified my schema, you can see it in attached file. > I'

[GENERAL] Function runtime increases after 5 calls in the same session.

2014-10-21 Thread Ilya I. Ashchepkov
Hi, all. I wrote a function and during testing it I came across the strange behaviour. Function runtime is about 200ms first 5 times, 6th and futher calls takes ~22000 ms. I simplified my schema, you can see it in attached file. I've tested on 9.4beta3 and 9.3.5. When I removed security_barrier f