pg_class.relpages documentation does not mention relpages corner case

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема pg_class.relpages documentation does not mention relpages corner case
Дата
Msg-id 168600622919.640.13784585346362749956@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: pg_class.relpages documentation does not mention relpages corner case
Список pgsql-docs
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

В списке pgsql-docs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: PostgreSQL 16 release notes: could cloud
Следующее
От: Daniel Gustafsson
Дата:
Сообщение: Re: confusing positioning of notes in connection settings