Content-Length: 273838 | pFad | http://github.com/postgrespro/postgres/commit/f9463d2a903da930531d124ea8bbbff8c097d86b

EB Fix inconsistency in pg_buffercache docs. · postgrespro/postgres@f9463d2 · GitHub
Skip to content

Commit f9463d2

Browse files
author
Amit Kapila
committed
Fix inconsistency in pg_buffercache docs.
Commit 6e65454 avoids locking bufmgr partitions to make pg_buffercache less disruptive on production systems but forgot to update the docs. Reported-by: Sawada Masahiko Author: Sawada Masahiko Reviewed-by: Amit Kapila Backpatch-through: 10 Discussion: https://postgr.es/m/CA+fd4k6sD8oeP1qJbFAor=rCpYckU9DsywHiYx3x5Hz5Z8Ua_w@mail.gmail.com
1 parent f2ff203 commit f9463d2

File tree

1 file changed

+5
-6
lines changed

1 file changed

+5
-6
lines changed

doc/src/sgml/pgbuffercache.sgml

Lines changed: 5 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -135,12 +135,11 @@
135135
</para>
136136

137137
<para>
138-
When the <structname>pg_buffercache</structname> view is accessed, internal buffer
139-
manager locks are taken for long enough to copy all the buffer state
140-
data that the view will display.
141-
This ensures that the view produces a consistent set of results, while not
142-
blocking normal buffer activity longer than necessary. Nonetheless there
143-
could be some impact on database performance if this view is read often.
138+
Since buffer manager locks are not taken to copy the buffer state data that
139+
the view will display, accessing <structname>pg_buffercache</structname> view
140+
has less impact on normal buffer activity but it doesn't provide a consistent
141+
set of results across all buffers. However, we ensure that the information of
142+
each buffer is self-consistent.
144143
</para>
145144
</sect2>
146145

0 commit comments

Comments
 (0)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/f9463d2a903da930531d124ea8bbbff8c097d86b

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy