Horton

Re: Discussion on missing optimizations

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, Andres Freund <andres@anarazel.de>, Adam Brusselback <adambrusselback@gmail.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2017-10-12T14:06:44Z
Lists: pgsql-hackers 
On Thu, Oct 12, 2017 at 10:00 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> From my experience with Oracle I would say that that is a can of worms.
>
> Yeah, I'm pretty suspicious of the idea too.  We've had an awful lot of
> bad experience with local plan caching, to the point where people wonder
> why we don't just auto-replan every time.  How would a shared cache
> make that better?  (Even assuming it was otherwise free, which it
> surely won't be.)

Obviously it wouldn't.  But it might make other things better.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Commits

  1. Reduce "X = X" to "X IS NOT NULL", if it's easy to do so.