measuring disk usage of records

From: "Matthew Nuzum" <cobalt(at)bearfruit(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: measuring disk usage of records
Date: 2003-12-31 20:58:57
Message-ID: 004b01c3cfe0$e8a669f0$6900a8c0@MATTSPC
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We've had a chance to talk to some of our competitors who have recently gone
out of business. One of the major failings that contributed to their
collapse was not accurately understanding how much disk space and bandwidth
they were using up. Therefore, they often lost money unexpectedly which, as
most of you know, is not sustainable.

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?

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message P.J. "Josh" Rovero 2003-12-31 21:20:09 Re: measuring disk usage of records
Previous Message Eric Ridge 2003-12-31 18:03:47 Re: website doc search is extremely SLOW