Re: [HACKERS] Making clausesel.c Smarter - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] Making clausesel.c Smarter
Date
Msg-id CA+Tgmoagx4vke2Eg9JR6QMSOWTYpe6nUkBLws55=4zabNXxhCg@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Making clausesel.c Smarter  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: [HACKERS] Making clausesel.c Smarter  (David Steele <david@pgmasters.net>)
List pgsql-hackers
On Fri, Feb 24, 2017 at 3:30 PM, David Rowley
<david.rowley@2ndquadrant.com> wrote:
> It would be good to improve the situation here in the back branches
> too, but I'm thinking that the attached might be a little invasive for
> that?

My experience has been that customers - at least EnterpriseDB
customers - do not appreciate plan changes when they upgrade to a new
minor release.  Most people have production installations that are
basically working; if not, they wouldn't be in production.  Even if
they're getting a good plan only by some happy accident, they're still
getting it, and a change can cause a good plan to flop over into a bad
plan, which can easily turn into a service outage.  The people who had
a bad plan and get flipped to a good plan will be happy once they
realize what has changed, of course, but that's not really enough to
make up from the panicked calls from customers whose stuff falls over
when they try to apply the critical security update.

I think the basic think you are trying to accomplish is sensible,
though.  I haven't reviewed the patch.

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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] Proposal : Parallel Merge Join
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] GUC for cleanup indexes threshold.