Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 905E29FBD0C for ; Wed, 27 Jun 2007 14:24:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 53506-05 for ; Wed, 27 Jun 2007 14:23:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s14.bay0.hotmail.com (bay0-omc3-s14.bay0.hotmail.com [65.54.246.214]) by postgresql.org (Postfix) with ESMTP id 088239FB939 for ; Wed, 27 Jun 2007 14:23:57 -0300 (ADT) Received: from hotmail.com ([207.46.11.98]) by bay0-omc3-s14.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 27 Jun 2007 10:23:57 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 27 Jun 2007 10:23:56 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Wed, 27 Jun 2007 17:23:51 GMT X-Originating-IP: [220.226.26.174] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: <20070627163333.054BD69B21@pitcher.impulsemg.com> From: "Vishal Arora" To: nbanks@impulsemg.com, pgsql-admin@postgresql.org Subject: Re: Determine/Calculate table size Date: Wed, 27 Jun 2007 17:23:51 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 27 Jun 2007 17:23:56.0877 (UTC) FILETIME=[F14AAFD0:01C7B8DF] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.673 tagged_above=0 required=5 tests=AWL=-2.006, BAYES_05=-1.11, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0, RCVD_IN_NJABL_PROXY=0.721, RCVD_IN_SBL=3.16 X-Spam-Level: ** X-Archive-Number: 200706/281 X-Sequence-Number: 25949 you can try for your reference http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE in earlier versions use the functions in contrib/dbsize. - Vishal >From: "Nathaniel Banks Jr." >To: >Subject: [ADMIN] Determine/Calculate table size >Date: Wed, 27 Jun 2007 12:32:08 -0400 > >Hello Gurus, > >I'm fairly new to Postgres and I was wondering what command/sql query >will give me a list of each table in a schema with it's size? I've >searched around and I haven't been able to find...I'm on postgres 7.3 by >the way > > > > > _________________________________________________________________ Like puzzles? Play free games & earn great prizes. Play Clink now. http://club.live.com/clink.aspx?icid=clink_hotmailtextlink2