pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedNo, that's backwards.
2+ messages / 2 participants
[nested] [flat]
Commits from this thread:
2017-07-09 485c515d01 eb01287c9d Doc: fix backwards description of visibility map's all-frozen data.
* No, that's backwards.
@ 2017-07-09 13:30 Vik Fearing <vik.fearing@2ndquadrant.com>
2017-07-09 16:52 ` Re: No, that's backwards. Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: Vik Fearing @ 2017-07-09 13:30 UTC (permalink / raw)
To: pgsql-docs
The documentation at
https://www.postgresql.org/docs/current/static/storage-vm.html says that
the visibility map "keeps track of which pages contain only unfrozen
tuples".
This is wrong; it keeps track of all-frozen pages not all-unfrozen.
Trivial patch attached.
--
Vik Fearing +33 6 46 75 15 36
http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Attachments:
unfrozen.patch (text/x-patch, 751B) download
diff --git a/doc/src/sgml/storage.sgml b/doc/src/sgml/storage.sgml
index a156693ec8..aed2cf8bca 100644
--- a/doc/src/sgml/storage.sgml
+++ b/doc/src/sgml/storage.sgml
@@ -630,7 +630,7 @@ can be used to examine the information stored in free space maps.
Each heap relation has a Visibility Map
(VM) to keep track of which pages contain only tuples that are known to be
visible to all active transactions; it also keeps track of which pages contain
-only unfrozen tuples. It's stored
+only frozen tuples. It's stored
alongside the main relation data in a separate relation fork, named after the
filenode number of the relation, plus a <literal>_vm</> suffix. For example,
if the filenode of a relation is 12345, the VM is stored in a file called
* Re: No, that's backwards.
2017-07-09 13:30 No, that's backwards. Vik Fearing <vik.fearing@2ndquadrant.com>
@ 2017-07-09 16:52 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2017-07-09 16:52 UTC (permalink / raw)
To: Vik Fearing <vik.fearing@2ndquadrant.com>; +Cc: pgsql-docs
Vik Fearing <vik.fearing@2ndquadrant.com> writes:
> The documentation at
> https://www.postgresql.org/docs/current/static/storage-vm.html says that
> the visibility map "keeps track of which pages contain only unfrozen
> tuples".
> This is wrong; it keeps track of all-frozen pages not all-unfrozen.
Yup. Pushed, thanks!
regards, tom lane
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2017-07-09 16:52 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2017-07-09 13:30 No, that's backwards. Vik Fearing <vik.fearing@2ndquadrant.com>
2017-07-09 16:52 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox