Function runtime increases after 5 calls in the same session.

Поиск
Список
Период
Сортировка
От Ilya I. Ashchepkov
Тема Function runtime increases after 5 calls in the same session.
Дата
Msg-id CALgmQD9ebXKPgbK5jjbaJ9kCWtOywjjpv-X9+eN0hn5gfGJOjQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Function runtime increases after 5 calls in the same session.  (Marti Raudsepp <marti@juffo.org>)
Список 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
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: ALTER TYPE ... ADD VALUE issue
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Yosemite (OSX 10.0) problems with Postgresql