From: | "Matthew Nuzum" <cobalt(at)bearfruit(dot)org> |
---|---|
To: | "'P(dot)J(dot) \"Josh\" Rovero'" <rovero(at)sonalysts(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: measuring disk usage of records |
Date: | 2003-12-31 21:32:51 |
Message-ID: | 000001c3cfe5$a56d73e0$6900a8c0@MATTSPC |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks for the very quick reply... I didn't know about the dbsize stuff,
they may help. Unfortunately, the records are mixed together.
I may have to use some judicious estimating... I'm just wondering if there's
something more scientific.
Matthew Nuzum | ISPs: Make $200 - $5,000 per referral by
www.followers.net | recomending Elite CMS to your customers!
matt(at)followers(dot)net | http://www.followers.net/isp
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of P.J. "Josh" Rovero
Sent: Wednesday, December 31, 2003 4:20 PM
To: Matthew Nuzum
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] measuring disk usage of records
Use contrib/dbsize, then you'll be able to
select relation_size('<table_name>');
select database_size('<database_name>');
Answers come back in bytes....
If the customer records are mixed with different customer
data in the same tables, it's a bit more complicated.
Matthew Nuzum wrote:
> Therefore, we'd like to avoid falling into the same trap and get a good
> understanding of how much storage space our customer's data is actually
> using.
>
> Here's the problem... A customer's data may be scattered across multiple
> tables. Some customers have X,000 records in table A, some have Y,000
> records in table B and etc. There's no way it can be as simple as saying
> "database takes X GB for Y customers so usage is X/Y"
>
> Does anyone have any suggestions that can help me to get access to this
> information?
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero(at)sonalysts(dot)com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Nolan | 2003-12-31 21:45:07 | Re: measuring disk usage of records |
Previous Message | P.J. "Josh" Rovero | 2003-12-31 21:20:09 | Re: measuring disk usage of records |