Horton

Re: Parallel Append subplan order instability on aye-aye

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2019-05-20T04:46:25Z
Lists: pgsql-hackers 
Thomas Munro <thomas.munro@gmail.com> writes:
> Here's a one-off regression test failure of a sort that commit
> 624e440a intended to fix.

Note that in the discussion that led up to 624e440a, we never did
think that we'd completely explained the original irreproducible
failure.

I think I've seen a couple of other cases of this same failure
in the buildfarm recently, but too tired to go looking right now.

			regards, tom lane

Commits

  1. ANALYZE a_star and its children to avoid plan instability in tests.

  2. Finish reverting "Insert temporary debugging output in regression tests."

  3. Partially revert "Insert temporary debugging output in regression tests."

  4. Insert temporary debugging output in regression tests.

  5. Improve the heuristic for ordering child paths of a parallel append.