Postgres Pro
Downloads
Home   >   mailing lists

Re: Add regression test checking combinations of (object,backend_type,context) in pg_stat_io - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: Add regression test checking combinations of (object,backend_type,context) in pg_stat_io
Date
Msg-id Z84cWxlOdGr6KEMC@paquier.xyz
Whole thread Raw
In response to Re: Add regression test checking combinations of (object,backend_type,context) in pg_stat_io  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
Tree view 
On Wed, Mar 05, 2025 at 09:19:16PM +0900, Michael Paquier wrote:
> On Wed, Mar 05, 2025 at 07:34:16AM +0000, Bertrand Drouvot wrote:
>> What about adding some extra paranoia like?
>>
>> SELECT backend_type, object, context FROM pg_stat_io ORDER BY
>> backend_type, object, context COLLATE "C";
>
> Why not, to force the ordering.

For the sake of the archives.  As 8b532771a099 has proved, this has
required two more COLLATE clauses in the query to force a stable
output, but we are in the clear now.
--
Michael
Attachment

pgsql-hackers by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: Special-case executor expression steps for common combinations
Next
From: Tomas Vondra
Date:
Subject: Re: Changing the state of data checksums in a running cluster