Quick Links

Re: installcheck failure in indirect_toast with default_toast_compression = lz4

From:	Justin Pryzby <pryzby(at)telsasoft(dot)com>
To:	Michael Paquier <michael(at)paquier(dot)xyz>
Cc:	pgsql-hackers(at)lists(dot)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>
Subject:	Re: installcheck failure in indirect_toast with default_toast_compression = lz4
Date:	2021-06-06 20:52:57
Message-ID:	20210606205257.GX14099@telsasoft.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

On Sat, Jun 05, 2021 at 09:20:43AM +0900, Michael Paquier wrote:
> As said in $subject, installcheck fails once I set up a server with
> default_toast_compression = lz4 in the test indirect_toast. Please
> see the attached for the diffs.
>
> The issue is that the ordering of the tuples returned by UPDATE
> RETURNING is not completely stable. Perhaps we should just enforce
> the order of those tuples by wrapping the DMLs into a CTE and use an
> ORDER BY in the outer query.

--
Justin

In response to

installcheck failure in indirect_toast with default_toast_compression = lz4 at 2021-06-05 00:20:43 from Michael Paquier

Responses

Re: installcheck failure in indirect_toast with default_toast_compression = lz4 at 2021-06-07 09:03:49 from Michael Paquier

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Justin Pryzby	2021-06-06 21:03:46	Re: Strangeness with UNIQUE indexes and UTF-8
Previous Message	Tom Lane	2021-06-06 20:08:52	Re: PoC/WIP: Extended statistics on expressions