pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rudi Starcevic <rudi@oasis.net.au>
To: pgsql-sql@postgresql.org
Subject: Re: Database / table sizeof
Date: Thu, 28 Mar 2002 16:27:32 +1000
Message-ID: <3CA2B7D4.7010803@oasis.net.au> (raw)
References: <GNELIHDDFBOCMGBFGEFOMEOJCBAA.chriskl@familyhealth.com.au>

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)
>






view thread (3+ messages)

Message-ID: <3CA2B7D4.7010803@oasis.net.au>
Permalink:  ../3CA2B7D4.7010803@oasis.net.au/
Also on:    postgresql.org/message-id/3CA2B7D4.7010803@oasis.net.au

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: rudi@oasis.net.au
  Subject: Re: Database / table sizeof
  In-Reply-To: <3CA2B7D4.7010803@oasis.net.au>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox