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

Commitbe25029

Browse files
Doc: indexUnchanged is strictly a hint.
Clearly spell out the limitations of aminsert()'s indexUnchanged hintingmechanism in the index AM documentation.Oversight in commit9dc718b, which added the "logically unchangedindex" hint (which is used to trigger bottom-up index deletion).Author: Peter Geoghegan <pg@bowt.ie>Reported-By: Tom Lane <tgl@sss.pgh.pa.us>Reviewed-By: Tom Lane <tgl@sss.pgh.pa.us>Discussion:https://postgr.es/m/CAH2-WzmU_BQ=-H9L+bxTSMQBqHMjp1DSwGypvL0gKs+dTOfkKg@mail.gmail.comBackpatch: 14-, where indexUnchanged hinting was introduced.
1 parent0e49e23 commitbe25029

File tree

1 file changed

+7
-3
lines changed

1 file changed

+7
-3
lines changed

‎doc/src/sgml/indexam.sgml

Lines changed: 7 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -319,9 +319,13 @@ aminsert (Relation indexRelation,
319319
modify any columns covered by the index, but nevertheless requires a
320320
new version in the index. The index AM may use this hint to decide
321321
to apply bottom-up index deletion in parts of the index where many
322-
versions of the same logical row accumulate. Note that updating a
323-
non-key column does not affect the value of
324-
<literal>indexUnchanged</literal>.
322+
versions of the same logical row accumulate. Note that updating a non-key
323+
column or a column that only appears in a partial index predicate does not
324+
affect the value of <literal>indexUnchanged</literal>. The core code
325+
determines each tuple's <literal>indexUnchanged</literal> value using a low
326+
overhead approach that allows both false positives and false negatives.
327+
Index AMs must not treat <literal>indexUnchanged</literal> as an
328+
authoritative source of information about tuple visibility or versioning.
325329
</para>
326330

327331
<para>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp