Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection
Дата
Msg-id 30125.1497195432@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I wrote:
> Right.  The plancache code is designed to switch to a generic plan if
> that doesn't seem to save anything compared to a custom plan that's
> built for the specific parameter value(s).

Er, -ENOCAFFEINE.  That's backwards of course.  I think the rest of
what I wrote is okay.

            regards, tom lane


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