Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection
Date
Msg-id 30125.1497195432@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] Inconsistent performance with LIKE and bind variable on long-lived connection  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100
Next
From: pinker
Date:
Subject: Re: [GENERAL] Huge Pages - setting the right value