pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Database / table sizeof
3+ messages / 2 participants
[nested] [flat]

* Database / table sizeof
@ 2002-03-28 05:54  Rudi Starcevic <rudi@oasis.net.au>
  0 siblings, 1 reply; 3+ messages in thread

From: Rudi Starcevic @ 2002-03-28 05:54 UTC (permalink / raw)
  To: pgsql-sql

    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.




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Database / table sizeof
@ 2002-03-28 06:06  Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  parent: Rudi Starcevic <rudi@oasis.net.au>
  0 siblings, 1 reply; 3+ messages in thread

From: Christopher Kings-Lynne @ 2002-03-28 06:06 UTC (permalink / raw)
  To: Rudi Starcevic <rudi@oasis.net.au>; pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Database / table sizeof
@ 2002-03-28 06:27  Rudi Starcevic <rudi@oasis.net.au>
  parent: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
  0 siblings, 0 replies; 3+ messages in thread

From: Rudi Starcevic @ 2002-03-28 06:27 UTC (permalink / raw)
  To: pgsql-sql

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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2002-03-28 06:27 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-28 05:54 Database / table sizeof Rudi Starcevic <rudi@oasis.net.au>
2002-03-28 06:06 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2002-03-28 06:27   ` Rudi Starcevic <rudi@oasis.net.au>

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