Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (Postfix) with ESMTP id 04CAB4758DC for ; Thu, 28 Mar 2002 01:29:17 -0500 (EST) Received: from oasis.net.au (guardian [210.8.139.5]) by water.oasis.net.au (8.9.3/100.1) with ESMTP id QAA17186 for ; Thu, 28 Mar 2002 16:32:43 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3CA2B7D4.7010803@oasis.net.au> Date: Thu, 28 Mar 2002 16:27:32 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:0.9.8) Gecko/20020204 X-Accept-Language: en-us MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Database / table sizeof References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Archive-Number: 200203/371 X-Sequence-Number: 7245 Thanks Christopher, Been looking so far but no joy. At worst a can write a script in Perl or PHP to go and select all records for a particular database, measure them by assigning each row to a variable in a loop and add them all up. Once for late at night / early morning. Cheers Rudi. Christopher Kings-Lynne wrote: >You can probably find something useful here: > >http://techdocs.postgresql.org/ > >Chris > >>-----Original Message----- >>From: pgsql-sql-owner@postgresql.org >>[mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Rudi Starcevic >>Sent: Thursday, 28 March 2002 1:55 PM >>To: pgsql-sql@postgresql.org >>Subject: [SQL] Database / table sizeof >> >> >> Hi, >> >>How can I measure how much hardrive space a user's database is using I >>wonder ? >>Someone could have '000's of small row's or perhaps 1 large BLOB. >>Is there a way I can add up all the row's for a database and end up with >>Kb's ? >> >>Thanks >>Regards Rudi. >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 2: you can get off all lists at once with the unregister command >> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >> > > >---------------------------(end of broadcast)--------------------------- >TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) >