X-Original-To: pgsql-admin@postgresql.org Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id EB25A47580B for ; Thu, 13 Mar 2003 23:37:45 -0500 (EST) Received: (qmail 27486 invoked from network); 14 Mar 2003 04:38:01 -0000 Received: from unknown (HELO system67.trade-india-local.com) (192.168.0.67) by infocom-236-129-del.trade-india.com with SMTP; 14 Mar 2003 04:38:01 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: Jodi Kanter Subject: Re: Table Sizes Date: Fri, 14 Mar 2003 10:07:43 +0530 User-Agent: KMail/1.5 References: <3E6BA947.3050205@waste.org> <200303101515.18859.mallah@trade-india.com> <010a01c2e983$5d8c0440$de138f80@virginia.edu> In-Reply-To: <010a01c2e983$5d8c0440$de138f80@virginia.edu> Cc: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200303141007.43467.mallah@trade-india.com> X-Archive-Number: 200303/208 X-Sequence-Number: 7848 You need to install the contrib/dbsize package. Yes it will work from psql. Not sure though if this contrib package is bundled with pgsql 7.2.3 , with 7.3.2 yes. regds mallah. On Thursday 13 Mar 2003 10:39 pm, you wrote: > I assume these command need to be run within psql? They don't work for me. > Could it be specific to a newer version? We are using 7.2.3 > Thanks > Jodi > > ----- Original Message ----- > From: "Rajesh Kumar Mallah" > To: "Ogden Nefix" ; > Sent: Monday, March 10, 2003 4:45 AM > Subject: Re: [ADMIN] Table Sizes > > > > > > use contrib/dbsize > > > > 1. select relation_size('schemaname.tablename'); > > 2. select database_size('databasename'); > > > > > > function 1 does not works with tablename in miXed CaSe. > > > > > > regds > > mallah. > > > > On Monday 10 Mar 2003 2:21 am, Ogden Nefix wrote: > > > Hi, > > > > > > Is it possible to find out the size of certain tables in PostgreSQL? If > > > so, how? > > > > > > Thank you > > > > > > Ogden > > > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > > TIP 4: Don't 'kill -9' the postmaster > > > > > > > > > > -- > > > > Regds > > Mallah > > > > ---------------------------------------- > > Rajesh Kumar Mallah, > > Project Manager (Development) > > Infocom Network Limited, New Delhi > > phone: +91(11)6152172 (221) (L) ,9811255597 (M) > > > > Visit http://www.trade-india.com , > > India's Leading B2B eMarketplace. > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 6: Have you searched our list archives? > > > > http://archives.postgresql.org > > > > > -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.