From nbanks@impulsemg.com Wed Jun 27 16:52:27 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1BDF79FB807 for ; Wed, 27 Jun 2007 13:52:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 50900-01 for ; Wed, 27 Jun 2007 13:52:21 -0300 (ADT) X-Greylist: delayed 00:18:36.285298 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2D9A69FBED4 for ; Wed, 27 Jun 2007 13:52:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from mycorporateemail.com (mycorporateemail.com [66.11.121.34]) by svr4.postgresql.org (Postfix) with ESMTP id 0104A5AF8A1 for ; Wed, 27 Jun 2007 16:33:43 +0000 (GMT) Received: from pitcher.impulsemg.com (pitcher.impulsemg.com [63.163.248.9]) by mycorporateemail.com (Postfix) with ESMTP id 52A9636D22 for ; Wed, 27 Jun 2007 02:28:49 -0400 (EDT) X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12 Content-Class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C7B8D8.B45D79EC" Subject: Determine/Calculate table size Date: Wed, 27 Jun 2007 12:32:08 -0400 X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Determine/Calculate table size thread-index: Ace42OO993PrWB9ISwqEx1N3KbLwJA== From: "Nathaniel Banks Jr." To: Message-Id: <20070627163333.054BD69B21@pitcher.impulsemg.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200706/280 X-Sequence-Number: 25948 This is a multi-part message in MIME format. ------_=_NextPart_001_01C7B8D8.B45D79EC Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 =20 =20 ------_=_NextPart_001_01C7B8D8.B45D79EC Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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

 

 

------_=_NextPart_001_01C7B8D8.B45D79EC-- From aroravishal22@hotmail.com Wed Jun 27 17:24:02 2007 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 From Jayakumar_Mukundaraju@satyam.com Thu Jun 28 06:07:23 2007 Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B7FC99FB6C3 for ; Thu, 28 Jun 2007 03:07:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 90412-06 for ; Thu, 28 Jun 2007 03:07:20 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from hydmail1.satyam.com (hydmail1.satyam.com [124.30.170.13]) by postgresql.org (Postfix) with ESMTP id 8227A9FA5B9 for ; Thu, 28 Jun 2007 03:07:19 -0300 (ADT) Received: from hyd.satyam.com (hyd.satyam.com [204.252.161.226]) by hydmail1.satyam.com (8.13.4/8.13.4) with ESMTP id l5S64EvB006314 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Thu, 28 Jun 2007 11:34:30 +0530 Received: from Disclaimerhyd.corp.satyam.ad (hhtbh.satyam.com [172.16.186.212]) by hyd.satyam.com (8.13.1/8.13.1) with ESMTP id l5S638Nu006652; Thu, 28 Jun 2007 11:33:17 +0530 Received: from hcsmsg002.corp.satyam.ad ([172.16.129.211]) by Disclaimerhyd.corp.satyam.ad with Microsoft SMTPSVC(6.0.3790.211); Thu, 28 Jun 2007 11:36:33 +0530 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.607 Content-Class: urn:content-classes:message MIME-Version: 1.0 Importance: normal Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: Re: Determine/Calculate table size Date: Thu, 28 Jun 2007 11:36:31 +0530 Message-ID: <8BE2E1772BEE8D40B0FB9E59DF2A645E06D33F29@hcsmsg002.corp.satyam.ad> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] Determine/Calculate table size thread-index: Ace44H9RW2gOP9r1TCyLugf1NPLq0AAZmhDg From: "Jayakumar_Mukundaraju" To: "Vishal Arora" , , X-OriginalArrivalTime: 28 Jun 2007 06:06:33.0648 (UTC) FILETIME=[7A73DB00:01C7B94A] X-Virus-Scanned: ClamAV version 0.88.4, clamav-milter version 0.88.4 on hyd.satyam.com X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/282 X-Sequence-Number: 25950 Hi Vishal, I need a help.. How to set the job scheduler in postgres windows box.. Thanks & Regards Jayakumar M -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal Arora Sent: Wednesday, June 27, 2007 10:54 PM To: nbanks@impulsemg.com; pgsql-admin@postgresql.org Subject: Re: [ADMIN] Determine/Calculate table size you can try for your reference http://www.postgresql.org/docs/8.2/interactive/functions-admin.html#FUNC TIONS-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.=20 http://club.live.com/clink.aspx?icid=3Dclink_hotmailtextlink2 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster DISCLAIMER: This email (including any attachments) is intended for the sole use of = the intended recipient/s and may contain material that is CONFIDENTIAL = AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or = copying or distribution or forwarding of any or all of the contents in = this message is STRICTLY PROHIBITED. If you are not the intended = recipient, please contact the sender by email and delete all copies; = your cooperation in this regard is appreciated.