Re: Stability of queryid in minor versions - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Stability of queryid in minor versions
Date
Msg-id CAKFQuwaLVg7Nz7is5zxi+SXbZNYH25xg1ErjWkuM96x5DOqooA@mail.gmail.com
Whole thread Raw
In response to [MASSMAIL]Stability of queryid in minor versions  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: Stability of queryid in minor versions
List pgsql-hackers
On Sun, Apr 14, 2024 at 4:20 PM David Rowley <dgrowleyml@gmail.com> wrote:

I've drafted a patch which I think improves things, but it probably
needs more work and opinions.


Seems we can improve things by simply removing the "rule of thumb" sentence altogether.  The prior paragraph states the things the queryid depends upon at the level of detail the reader needs.

The sentence "Two servers participating in replication based on physical WAL replay can be expected to have identical queryid values for the same query." apparently assumes that to participate both servers must share the same machine architecture.  I am under the impression that this is only an advisory, not a requirement.  Rather, two servers participating in physical replication will be ensured that the catalog metadata and major versions are identical.  This is not the case for servers related via logical replication.

David J.

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Stability of queryid in minor versions
Next
From: Michael Paquier
Date:
Subject: Re: ALTER TABLE SET ACCESS METHOD on partitioned tables