Re: PostgreSQL 9.5.14 Documentation /Chapter 28 / 28.1. DeterminingDisk Usage

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: PostgreSQL 9.5.14 Documentation /Chapter 28 / 28.1. DeterminingDisk Usage
Дата
Msg-id CAKFQuwaaAGu1Eb8MQzx7kuuy-1Dkkga5NJH4wDKXgVv4kygJJg@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL 9.5.14 Documentation /Chapter 28 / 28.1. Determining DiskUsage  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
Дерево обсуждения
On Wed, Sep 5, 2018 at 4:43 AM, PG Doc comments form <noreply@postgresql.org> wrote:
I'm wondering if the two statements given showing the index space size as
described.
I've the impression they show the space size of the tables.  

"Each page is typically 8 kilobytes. (Remember, relpages is only updated by VACUUM, ANALYZE, and a few DDL commands such as CREATE INDEX.)"

So while it takes a bit of interpretation it is stated that "relpages" are not a size on their own but a value to be multiplied by 8k to come up with the disk size (typically since one can compile the server with a different page size).

David J.

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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: PostgreSQL 9.5.14 Documentation /Chapter 28 / 28.1. Determining DiskUsage
Следующее
От: Liudmila Mantrova
Дата:
Сообщение: Re: Misc typos in documentation