Re: Performance problem in PLPgSQL

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance problem in PLPgSQL
Дата
Msg-id 352.1374588018@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Performance problem in PLPgSQL  (Marc Cousin <cousinmarc@gmail.com>)
Ответы Re: Performance problem in PLPgSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Marc Cousin <cousinmarc@gmail.com> writes:
> The example below is of course extremely simplified, and obviously not
> what we are really doing in the database, but it exhibits the slowdown
> between 9.1.9 and 9.2.4.

Hm.  Some experimentation shows that the plan cache is failing to switch
to a generic plan, but I'm not sure why the cast would have anything to
do with that ...
        regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: make --silent
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Bloom Filter lookup for hash joins