Re: PoC plpgsql - possibility to force custom or genericplan

Поиск
Список
Период
Сортировка
От Petr Jelinek
Тема Re: PoC plpgsql - possibility to force custom or genericplan
Дата
Msg-id 0d34290e-3afe-efd1-be3a-ae0ce03c1677@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] PoC plpgsql - possibility to force custom or generic plan  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
On 05/04/17 23:22, Tom Lane wrote:
> Andres Freund <andres@anarazel.de> writes:
>> I'd like some input from other committers whether we want this.  I'm
>> somewhat doubtful, but don't have particularly strong feelings.
> 
> I don't really want to expose the workings of the plancache at user level.
> The heuristics it uses certainly need work, 

That's an understatement, there are thousands of plpgsql functions in
large installations of PostgreSQL which use EXECUTE everywhere just to
avoid current behavior (and that's just what I've seen).

--  Petr Jelinek                  http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Declarative partitioning vs. information_schema
Следующее
От: Kyotaro HORIGUCHI
Дата:
Сообщение: Duplicate usage of tablespace location?