🌐 AI搜索 & 代理 主页
Skip to content

Commit a59b039

Browse files
committed
Doc: fix typo in hash index documentation
Plus a similar fix to the README. Backpatch as far back as the sgml issue exists. The README issue does exist in v14, but that seems unlikely to harm anyone. Author: David Geier <geidav.pg@gmail.com> Discussion: https://postgr.es/m/ed3db7ea-55b4-4809-86af-81ad3bb2c7d3@gmail.com Backpatch-through: 15
1 parent 5278222 commit a59b039

File tree

2 files changed

+8
-10
lines changed

2 files changed

+8
-10
lines changed

doc/src/sgml/hash.sgml

Lines changed: 4 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -125,11 +125,10 @@
125125
Both scanning the index and inserting tuples require locating the bucket
126126
where a given tuple ought to be located. To do this, we need the bucket
127127
count, highmask, and lowmask from the metapage; however, it's undesirable
128-
for performance reasons to have to have to lock and pin the metapage for
129-
every such operation. Instead, we retain a cached copy of the metapage
130-
in each backend's relcache entry. This will produce the correct bucket
131-
mapping as long as the target bucket hasn't been split since the last
132-
cache refresh.
128+
for performance reasons to have to lock and pin the metapage for every such
129+
operation. Instead, we retain a cached copy of the metapage in each
130+
backend's relcache entry. This will produce the correct bucket mapping as
131+
long as the target bucket hasn't been split since the last cache refresh.
133132
</para>
134133

135134
<para>

src/backend/access/hash/README

Lines changed: 4 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -171,11 +171,10 @@ Metapage Caching
171171
Both scanning the index and inserting tuples require locating the bucket
172172
where a given tuple ought to be located. To do this, we need the bucket
173173
count, highmask, and lowmask from the metapage; however, it's undesirable
174-
for performance reasons to have to have to lock and pin the metapage for
175-
every such operation. Instead, we retain a cached copy of the metapage
176-
in each backend's relcache entry. This will produce the correct
177-
bucket mapping as long as the target bucket hasn't been split since the
178-
last cache refresh.
174+
for performance reasons to have to lock and pin the metapage for every such
175+
operation. Instead, we retain a cached copy of the metapage in each backend's
176+
relcache entry. This will produce the correct bucket mapping as long as the
177+
target bucket hasn't been split since the last cache refresh.
179178

180179
To guard against the possibility that such a split has occurred, the
181180
primary page of each bucket chain stores the number of buckets that

0 commit comments

Comments
 (0)