Home > mailing lists

Function runtime increases after 5 calls in the same session. - Mailing list pgsql-general

From	Ilya I. Ashchepkov
Subject	Function runtime increases after 5 calls in the same session.
Date	October 21, 2014 12:53:55
Msg-id	CALgmQD9ebXKPgbK5jjbaJ9kCWtOywjjpv-X9+eN0hn5gfGJOjQ@mail.gmail.com Whole thread Raw
Responses	Re: Function runtime increases after 5 calls in the same session. (Marti Raudsepp <marti@juffo.org>)
List	pgsql-general

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 from the view or alter column "time" type to integer (bigint, I don't remember) all goes as expected.

It looks very strange for me.

I will be pleased if somebody checks this.

--
С уважением,
Ащепков Илья koctep@gmail.com

From: David G Johnston
Date: 20 October 2014, 23:28:20
Subject: Re: ALTER TYPE ... ADD VALUE issue

From: Craig Ringer
Date: 21 October 2014, 13:04:34
Subject: Re: Yosemite (OSX 10.0) problems with Postgresql