Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxfWB-00034P-D5 for pgsql-docs@arkaria.postgresql.org; Wed, 05 Sep 2018 21:39:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fxfW9-0000Pm-L6 for pgsql-docs@arkaria.postgresql.org; Wed, 05 Sep 2018 21:39:17 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxfW9-0000Pf-DO for pgsql-docs@lists.postgresql.org; Wed, 05 Sep 2018 21:39:17 +0000 Received: from mail-qt0-x243.google.com ([2607:f8b0:400d:c0d::243]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fxfW6-0007tJ-Pb for pgsql-docs@lists.postgresql.org; Wed, 05 Sep 2018 21:39:16 +0000 Received: by mail-qt0-x243.google.com with SMTP id t5-v6so9972096qtn.3 for ; Wed, 05 Sep 2018 14:39:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=e22VZn5dDAzmYXHTMpZdfIVHPeTNSB9dzDCxZsf9Pfc=; b=U79zFbqCV41bOuDxAy+xMslbZKRYMmxk/sXjPrcqu+SujxSla22/rjzTMIXPDMGdbs 3GA1CKie3kUqlf30S7x6SNAtYnhuyfLApWwHwVJkFR5yyOiPiLtcN9Tvxp5qGFKzGyWo Iw17Yjo7I60+62NlOOKrySPJF58PjBUHAUsptwvcO0nNlDnyO1neEGqwAi23pXKr6Y2y 2BrEBrOU/hTnmHiZRHXNTplKuBM0AK4RWKcDtAd8yUBII+J3mLymz9J57Qxkhoygv0t1 Z0L4pRRbhNEA4XJhTa6gTXvKvig65jXf5mG1qGFUdLbjhF4objkcRzV5Shq8gshToj23 GMVw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=e22VZn5dDAzmYXHTMpZdfIVHPeTNSB9dzDCxZsf9Pfc=; b=d58s263JWel15HAvRyeL3S1ojFGo7eXyAKfi86JoIjoGOAnCE+3pmdsva3HE1hQdnj uQG5PTzrr/XlQYIVHUMXxPY0NpC98e9HDsGRL5iaUIFS+IunlqL6tiGZQg3dsgBbJKO9 PI9bRZ4ck7bBDvrQYRWBwxxonpKRLdi6X0Gz2OLfmwBH4iRxlMKnmvWCVxI8wbE2iFrz tdpHlswbaQz6V5af+r+i1/EEShWPopqh90PYlqr0Jc5eW4rOnNNoRa3gdeKNmrcAYwCW MLmHxqH2cwhzjFtL7vTopdWUKk+ULcOIrAOuRF061x3T144LdmKk842IJt9yaeWcuq5C sCkg== X-Gm-Message-State: APzg51AoEWIasJ7VdZmHGIFAbFNaMOMUoc6PVaD01qwUC4+8SzRaIu51 yD5tl97IJdLMDFNarDeP015ZbNBmDeu/23z8CWQ= X-Google-Smtp-Source: ANB0VdaPiOutGCRevaYtQ96DaYuRR+EvEpsOrFHa6gHtoSzmyjR9dXt0eSSMj60NN70TtlouKgNtLs7J7hW5GYRRchg= X-Received: by 2002:ac8:9e:: with SMTP id c30-v6mr35448185qtg.173.1536183551903; Wed, 05 Sep 2018 14:39:11 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a0c:bf98:0:0:0:0:0 with HTTP; Wed, 5 Sep 2018 14:39:11 -0700 (PDT) In-Reply-To: <153614783570.23141.4323003313980257657@wrigleys.postgresql.org> References: <153614783570.23141.4323003313980257657@wrigleys.postgresql.org> From: "David G. Johnston" Date: Wed, 5 Sep 2018 14:39:11 -0700 Message-ID: Subject: Re: PostgreSQL 9.5.14 Documentation /Chapter 28 / 28.1. Determining Disk Usage To: michael.dietrich@swisscom.com, pgsql-docs@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000ebcd040575269ab9" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000ebcd040575269ab9 Content-Type: text/plain; charset="UTF-8" On Wed, Sep 5, 2018 at 4:43 AM, PG Doc comments form 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. --000000000000ebcd040575269ab9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Se= p 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 spa= ce size as
described.
I've the impression they show the space size of the tables.=C2=A0=C2=A0=

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

So while it takes = a bit of interpretation it is stated that "relpages" are not a si= ze 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 siz= e).

David J.

--000000000000ebcd040575269ab9--