Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 561E19FA4B2 for ; Wed, 27 Dec 2006 22:54:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 74976-01 for ; Wed, 27 Dec 2006 22:54:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31810.mail.mud.yahoo.com (web31810.mail.mud.yahoo.com [68.142.207.73]) by postgresql.org (Postfix) with SMTP id D6E929FA49D for ; Wed, 27 Dec 2006 22:54:46 -0400 (AST) Received: (qmail 44672 invoked by uid 60001); 28 Dec 2006 02:54:45 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=JIIBhfnroJCzDr8q7xsWv1e/7RP96xzGUUpXDAN8QVsYCbRvlijah9ZOTR09evUM4uqxNHeJXvks8UL3uLGxjhLIMrLCKM6cjvhBSAghuEZlQFU/VKHAuBLCoywKFo15wjzYm6rvOZK5pZQzAiY3RFKw+oADu7MUp1SikUS1idM=; X-YMail-OSG: ANpVjekVM1mdl8ZnMV6e.3AMiVvFYlVX9hInH2a0PS3EkINuxqRT_wB0ezMfXWWnG_.9Yx2LDRSAOhYKqkVid9ZAWg75KXxZjCgVgBbCBda706e_wnfevL__kDjn3HiPitfW85UCLEEGrCZxIDreO7ubEp.PXKou_g-- Received: from [75.84.83.178] by web31810.mail.mud.yahoo.com via HTTP; Wed, 27 Dec 2006 18:54:44 PST Date: Wed, 27 Dec 2006 18:54:44 -0800 (PST) From: Richard Broersma Jr Subject: Re: Need Help To: JM , pgsql-general@postgresql.org Cc: "Pgsql-Performance \(E-mail\)" In-Reply-To: <200612281042.52575.jerome@gmanmi.tv> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <151434.43695.qm@web31810.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.833 tagged_above=0 required=5 tests=AWL, BAYES_00, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200612/1492 X-Sequence-Number: 106430 --- JM wrote: > how can i get the disk usage for each table? can i do it via SQL? This function should do what you want: pg_relation_size(text) or pg_total_relation_size(text) I found it on the following link: http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNCTIONS-ADMIN-DBSIZE Regards, Richard Broersma Jr.