X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 23BFE9FB277 for ; Tue, 8 Aug 2006 12:38:17 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 43603-05 for ; Tue, 8 Aug 2006 15:38:14 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from newgen.co.in (mx.newgen.co.in [202.131.146.227]) by postgresql.org (Postfix) with SMTP id 6EFA19FB271 for ; Tue, 8 Aug 2006 12:38:12 -0300 (ADT) Received: (qmail 6137 invoked by uid 507); 8 Aug 2006 15:38:11 -0000 Received: from 202.140.41.205 by mx.newgen.co.in (envelope-from , uid 501) with qmail-scanner-1.25 (fireav: ???. spamassassin: 3.1.3. Clear:RC:0(202.140.41.205):SA:0(-100.0/5.0):. Processed in 2.542429 secs); 08 Aug 2006 15:38:11 -0000 Received: from unknown (HELO ngmail.newgen.co.in) (okhlaoffice@202.140.41.205) by mx.newgen.co.in with SMTP; 8 Aug 2006 15:38:08 -0000 Received: (qmail 15210 invoked by uid 504); 8 Aug 2006 15:37:31 -0000 Received: from ghanshyam@newgen.co.in by ngmail.newgen.co.in by uid 501 with qmail-scanner-1.21 (fireav: ???. Clear:RC:1(192.168.5.190):. Processed in 2.237708 secs); 08 Aug 2006 15:37:31 -0000 Received: from unknown (HELO ng3024) (192.168.5.190) by 192.168.5.243 with SMTP; 8 Aug 2006 15:37:29 -0000 Message-ID: <020e01c6bb00$8e385b50$be05a8c0@ng3024> From: "Sharma;G.S." To: Subject: How to know the sizes of all tables & indexes in a database Date: Tue, 8 Aug 2006 21:07:28 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_020B_01C6BB2E.A7DCC130" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.69 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, HTML_TEXT_AFTER_BODY X-Spam-Level: X-Archive-Number: 200608/93 X-Sequence-Number: 22637 This is a multi-part message in MIME format. ------=_NextPart_000_020B_01C6BB2E.A7DCC130 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Postgres 7.3 Is there any way to know the size taken up by each table and indexes in = postgres . I am having a 53 GB database which contains tables , indexes, functions = etc , how i can distribute these 53 GB's in database objects . Thanks in advance ------=_NextPart_000_020B_01C6BB2E.A7DCC130 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
Postgres 7.3
Is there any way to know the size taken = up by each=20 table and indexes in postgres .
I am having a 53 GB database which = contains tables=20 , indexes, functions etc , how i can distribute these 53 GB's in = database=20 objects .
 
Thanks in advance =
Disclaimer :- This e-mail message including any attachment may contain confidential, proprietary or legally privileged information. It should not be used by who is not the original intended recipient. If you have erroneously received this message, you are notified that you are strictly prohibited from using, copying, altering or disclosing the content of this message. Please delete it immediately and notify the sender. Newgen Software Technologies Ltd and / or its subsidiary Companies accept no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus and further acknowledges that any views expressed in this message are those of the individual sender and no binding nature of the message shall be implied or assumed unless the sender does so expressly with due authority of Newgen Software Technologies Ltd and / or its subsidiary Companies, as applicable. ------=_NextPart_000_020B_01C6BB2E.A7DCC130--