Horton

Re: PGOPTIONS="-fh" make check gets stuck since Postgres 11

Melanie Plageman <melanieplageman@gmail.com>

View thread View on postgr.es
From: Melanie Plageman <melanieplageman@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Michael Paquier <michael@paquier.xyz>, Thomas Munro <thomas.munro@gmail.com>, Postgres hackers <pgsql-hackers@lists.postgresql.org>
Date: 2019-07-09T18:54:29Z
Lists: pgsql-hackers 
On Mon, Jul 8, 2019 at 12:21 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> The point of regressplans.sh is to see if anything goes seriously
> wrong when forcing non-default plan choices --- seriously wrong being
> defined as crashes or semantically wrong answers.  It's not expected
> that the regression tests will automatically pass when you do that,
> because of their dependencies on output row ordering, not to mention
> all the EXPLAINs.  I'm not for removing it --- the fact that its
> results require manual evaluation doesn't make it useless.
>
>
It might be worth post-processing results files to ignore row ordering
in some cases to allow for easier comparison. Has this been proposed
in the past?

-- 
Melanie Plageman

Commits

  1. Force hash joins to be enabled in the hash join regression tests.