Estimating Database Disk Space
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
Attachments:
temp.postgres.diskstore.txttext/plain; charset=us-ascii; name=temp.postgres.diskstore.txtDownload
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@gmx.net