From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: m.sakrejda@gmail.com
Subject: pg_class.relpages documentation does not mention relpages corner case
Date: Mon, 05 Jun 2023 23:03:49 +0000
Message-ID: <168600622919.640.13784585346362749956@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/catalog-pg-class.html
Description:
In the pg_class documentation [1], the relpages column is described as
>Size of the on-disk representation of this table in pages (of size BLCKSZ).
This is only an estimate used by the planner. It is updated by VACUUM,
ANALYZE, and a few DDL commands such as CREATE INDEX.
However, it looks like this is -1 for partitioned tables. At least for ones
that have children and have been analyze since adding a child partition, it
seems. I'm not sure how to word that concisely, but should the documentation
note this case? Or can this just be zero for partitioned tales? I'm not sure
if it's too late for that, but they don't actually have any relpages, so it
seems odd that they need a sentinel value.
Thanks,
Maciek
[1]: https://www.postgresql.org/docs/current/catalog-pg-class.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, m.sakrejda@gmail.com
Subject: Re: pg_class.relpages documentation does not mention relpages corner case
In-Reply-To: <168600622919.640.13784585346362749956@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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