Re: PostgreSQL 9.5.14 Documentation /Chapter 28 / 28.1. Determining Disk Usage

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: michael(dot)dietrich(at)swisscom(dot)com, pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL 9.5.14 Documentation /Chapter 28 / 28.1. Determining Disk Usage
Date: 2018-09-05 21:39:11
Message-ID: CAKFQuwaaAGu1Eb8MQzx7kuuy-1Dkkga5NJH4wDKXgVv4kygJJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Wed, Sep 5, 2018 at 4:43 AM, PG Doc comments form <noreply(at)postgresql(dot)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.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Liudmila Mantrova 2018-09-06 15:45:29 Re: Misc typos in documentation
Previous Message PG Doc comments form 2018-09-05 11:43:55 PostgreSQL 9.5.14 Documentation /Chapter 28 / 28.1. Determining Disk Usage