X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8262FD1B1B9; Fri, 11 Jun 2004 13:24:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08368-02; Fri, 11 Jun 2004 16:24:03 +0000 (GMT) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id A8908D1B19C; Fri, 11 Jun 2004 13:24:00 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i5BGNeL09657; Fri, 11 Jun 2004 12:23:40 -0400 (EDT) From: Bruce Momjian Message-Id: <200406111623.i5BGNeL09657@candle.pha.pa.us> Subject: Re: Calculating size of the database tables In-Reply-To: To: akuppachi@hss.hns.com Date: Fri, 11 Jun 2004 12:23:40 -0400 (EDT) Cc: Devrim GUNDUZ , pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/150 X-Sequence-Number: 13810 Have you read the documentation section on managing disk space? --------------------------------------------------------------------------- akuppachi@hss.hns.com wrote: [ There is text before PGP section. ] > > > > > Hi, > > Thanks for the response. However, the README.dbsize says that "When > computing the size of a table, it does not include TOAST or index disk > space." So dbsize would not be giving me the total diskspace occupied by my > tables, right ? I need to know the full disk space so i can do some hard > disk size calculations. Is there any other way to do this? > > TIA, > Aparna. > > > > > > Devrim GUNDUZ > g> To > Sent by: akuppachi@hss.hns.com > pgsql-admin-owner cc > @postgresql.org pgsql-admin@postgresql.org > Subject > Re: [ADMIN] Calculating size of the > 06/10/04 04:25 PM database tables > > > > > > > > > > [ PGP not available, raw data follows ] > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > > Hi, > > On Thu, 10 Jun 2004 akuppachi@hss.hns.com wrote: > > > > I would appreciate any pointers to finding out the correct size occupied > by > > my database tables. Will the physical size of the "data" folder (as given > > by 'ls' command) give me the true size, or is there any other sql command > > that i can use to get this information? I am using PostgreSQL, version > > 7.4.1 server libraries. > > Please see contrib/dbsize. From README file: > > " > This module contains two functions that report the size of a given > database or relation. E.g., > > SELECT database_size('template1'); > SELECT relation_size('pg_class'); > > These functions report the actual file system space. Thus, users can > avoid digging through the details of the database directories. > " > > Regards, > - -- > Devrim GUNDUZ > devrim~gunduz.org > devrim.gunduz~linux.org.tr > http://www.tdmsoft.com > http://www.gunduz.org > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (GNU/Linux) > > iD8DBQFAyD48tl86P3SPfQ4RAu+dAJ9L4sfyaR9VRAA9jATcHxB/p9+lLQCg4/3a > jlDyuD1rOxNrij7UqX5xuKs= > =B0Mo > -----END PGP SIGNATURE----- > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > [ End of raw data] -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073