Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit2d3389c

Browse files
committed
Doc: document cases where queryid is stable
The documents were clear that queryid should not be assumed to be stablebetween major versions but said nothing about minor versions and leftthe reader to guess if that was implied by the mention of theinstability of queryid between major versions.Here we give minor versions an explicit mention to indicate queryid cangenerally be assumed stable between minor versions.Reviewed-by: Michael PaquierDiscussion:https://postgr.es/m/CAApHDvpYGE6h0cD9UO-eHySPynPj1L3J%3DHxT%2BA7Ud8_Yo6AuzA%40mail.gmail.comBackpatch-through: 12
1 parent82023d4 commit2d3389c

File tree

1 file changed

+15
-9
lines changed

1 file changed

+15
-9
lines changed

‎doc/src/sgml/pgstatstatements.sgml

Lines changed: 15 additions & 9 deletions
Original file line numberDiff line numberDiff line change
@@ -639,15 +639,21 @@
639639
</para>
640640

641641
<para>
642-
As a rule of thumb, <structfield>queryid</structfield> values can be assumed to be
643-
stable and comparable only so long as the underlying server version and
644-
catalog metadata details stay exactly the same. Two servers
645-
participating in replication based on physical WAL replay can be expected
646-
to have identical <structfield>queryid</structfield> values for the same query.
647-
However, logical replication schemes do not promise to keep replicas
648-
identical in all relevant details, so <structfield>queryid</structfield> will
649-
not be a useful identifier for accumulating costs across a set of logical
650-
replicas. If in doubt, direct testing is recommended.
642+
Two servers participating in replication based on physical WAL replay can
643+
be expected to have identical <structfield>queryid</structfield> values for
644+
the same query. However, logical replication schemes do not promise to
645+
keep replicas identical in all relevant details, so
646+
<structfield>queryid</structfield> will not be a useful identifier for
647+
accumulating costs across a set of logical replicas.
648+
If in doubt, direct testing is recommended.
649+
</para>
650+
651+
<para>
652+
Generally, it can be assumed that <structfield>queryid</structfield> values
653+
are stable between minor version releases of <productname>PostgreSQL</productname>,
654+
providing that instances are running on the same machine architecture and
655+
the catalog metadata details match. Compatibility will only be broken
656+
between minor versions as a last resort.
651657
</para>
652658

653659
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp