From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pgsql: Charge cpu_tuple_cost * 0.5 for Append and MergeAppend nodes. |
Date: | 2018-02-22 13:31:30 |
Message-ID: | CA+TgmoZVzjk-6dxQ1gHhhsT7Re3t=gmWB9_zoHrqxtO74W0M2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers pgsql-hackers |
On Thu, Feb 22, 2018 at 12:35 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <rhaas(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2018-02-22 13:54:35 | pgsql: Try to stabilize EXPLAIN output in partition_check test. |
Previous Message | Tom Lane | 2018-02-22 05:35:13 | Re: pgsql: Charge cpu_tuple_cost * 0.5 for Append and MergeAppend nodes. |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2018-02-22 13:34:30 | check error messages in SSL tests |
Previous Message | Peter Eisentraut | 2018-02-22 13:25:45 | phasing out pg_pltemplate? |