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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Следующее
От: pinker
Дата:
Сообщение: Re: [GENERAL] Huge Pages - setting the right value