Re: PGOPTIONS="-fh" make check gets stuck since Postgres 11 - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: PGOPTIONS="-fh" make check gets stuck since Postgres 11
Date
Msg-id 20190710074002.GE5042@paquier.xyz
Whole thread Raw
In response to Re: PGOPTIONS="-fh" make check gets stuck since Postgres 11  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: PGOPTIONS="-fh" make check gets stuck since Postgres 11  (Melanie Plageman <melanieplageman@gmail.com>)
Re: PGOPTIONS="-fh" make check gets stuck since Postgres 11  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, Jul 10, 2019 at 12:51:28PM +0530, Amit Kapila wrote:
> It would be good if we can come up with something like that.  It will
> be helpful for zheap, where in some cases we get different row
> ordering due to in-place updates.  As of now, we try to add Order By
> or do some extra magic to get consistent row ordering.

That was an issue for me as well when working with Postgres-XC when
the row ordering was not guaranteed depending on the number of nodes
(speaking of which Greenplum has the same issues, no?).  Adding ORDER
BY clauses to a set of tests may make sense, but then this may impact
the plans generated for some of them..
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Excessive memory usage in multi-statement queries w/ partitioning
Next
From: Kyotaro Horiguchi
Date:
Subject: Re: FETCH FIRST clause PERCENT option