| Lists: | pgsql-docs |
|---|
| From: | Richard A Lough <ralough(dot)ced(at)dnet(dot)co(dot)uk> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Estimating Database Disk Space |
| Date: | 2002-04-02 17:42:24 |
| Message-ID: | 3CA9ED80.40F2B87C@dnet.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
Hi All,
I have attached my attempt at documenting the use of
hard disk storage by a postgres database. I'll point out
that I am still on the learning curve for postgres, and
my assumptions may well be completely wrong.
The main point I think that needs validation is whether
it is best to create a model of a database in order to get
an accurate estimate of the space needed.
TIA
Richard A Lough
| Attachment | Content-Type | Size |
|---|---|---|
| temp.postgres.diskstore.txt | text/plain | 5.4 KB |
| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | <ralough(at)iee(dot)org> |
| Cc: | <pgsql-docs(at)postgresql(dot)org> |
| Subject: | Re: Estimating Database Disk Space |
| Date: | 2002-04-03 04:55:11 |
| Message-ID: | Pine.LNX.4.30.0204022352330.686-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
Richard A Lough writes:
> The main point I think that needs validation is whether
> it is best to create a model of a database in order to get
> an accurate estimate of the space needed.
That's pretty much it. If you want to know how much space something is
going to take, create it and look at it. I don't think we want to get
users involved into counting the bits of each piece of overhead that comes
with a database. That creates assumptions that are going to be hard to
overcome or change in the future.
--
Peter Eisentraut peter_e(at)gmx(dot)net