Re: plan cache overhead on plpgsql expression

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: plan cache overhead on plpgsql expression
Дата
Msg-id CA+HiwqHuEmzTnYZaJp8D14VCc127dnAKdAWZoV-b6U7oO_oOJg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: plan cache overhead on plpgsql expression  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: plan cache overhead on plpgsql expression  (Amit Langote <amitlangote09@gmail.com>)
Список pgsql-hackers
On Wed, Feb 19, 2020 at 3:38 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:
> st 19. 2. 2020 v 7:30 odesílatel Pavel Stehule <pavel.stehule@gmail.com> napsal:
>> út 18. 2. 2020 v 17:08 odesílatel Amit Langote <amitlangote09@gmail.com> napsal:
>>> > I updated the patch to do that.
>>> >
>>> > With the new patch, `select foo()`, with inline-able sql_incr() in it,
>>> > runs in 679 ms.
>>> >
>>> > Without any inline-able function, it runs in 330 ms, whereas with
>>> > HEAD, it takes 590 ms.
>>>
>>> I polished it a bit.
>>
>>
>> the performance looks very interesting - on my comp the execution time of  100000000 iterations was decreased from
34sec to 15 sec, 
>>
>> So it is interesting speedup
>
> but regress tests fails

Oops, I failed to check src/pl/plpgsql tests.

Fixed in the attached.

Thanks,
Amit

Вложения

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: plan cache overhead on plpgsql expression
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Yet another fast GiST build