Re: pgsql: Charge cpu_tuple_cost * 0.5 for Append and MergeAppend nodes. - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pgsql: Charge cpu_tuple_cost * 0.5 for Append and MergeAppend nodes.
Date
Msg-id CA+TgmoZVzjk-6dxQ1gHhhsT7Re3t=gmWB9_zoHrqxtO74W0M2w@mail.gmail.com
Whole thread Raw
Responses Re: pgsql: Charge cpu_tuple_cost * 0.5 for Append and MergeAppend nodes.  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Thu, Feb 22, 2018 at 12:35 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <rhaas@postgresql.org> writes:
>> Charge cpu_tuple_cost * 0.5 for Append and MergeAppend nodes.
>
> This seems to have produced some plan instability in the buildfarm.

I was worried about that.  Looking at it now.  I wish we had some way
to figure out whether a given plan was likely to be unstable on the
buildfarm other than committing it and seeing what happens.  It's
surprisingly difficult to write non-trivial tests that produce
consistent EXPLAIN output, and annoyingly time-consuming to try to
figure out why they don't.

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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: phasing out pg_pltemplate?
Next
From: Peter Eisentraut
Date:
Subject: check error messages in SSL tests