Re: Parallel append plan instability/randomness - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Parallel append plan instability/randomness
Date
Msg-id CA+Tgmoaho8_QinAxEbKQ0UCHdK9VpnZvYLCfrs2R=3UHQqN+ug@mail.gmail.com
Whole thread Raw
In response to Re: Parallel append plan instability/randomness  (Jim Finnerty <jfinnert@amazon.com>)
List pgsql-hackers
On Mon, Jan 8, 2018 at 1:26 PM, Jim Finnerty <jfinnert@amazon.com> wrote:
> I see.  Maybe the EXPLAIN output can be made more stable when "EXPLAIN (costs
> FALSE)", though?

I think that would be fixing the problem from the wrong end.  We want
to actually get a stable choice of plan, not display something other
than the actual plan because that other thing is more stable.

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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Parallel append plan instability/randomness
Next
From: Robert Haas
Date:
Subject: Re: Condition variable live lock