From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Bryan Field-Elliot <bryan_lists(at)netmeme(dot)org> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to estimate disk space requirements? |
Date: | 2001-04-26 15:27:41 |
Message-ID: | 16320.988298861@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bryan Field-Elliot <bryan_lists(at)netmeme(dot)org> writes:
> I have an application for PostgreSQL which may create some pretty huge
> databases. I need some way to estimate how much physical disk space will
> be required. I know the exact record structure and indexing schemes to
> be used, and a rough idea of the number of rows I'll need. Given that,
> how can I determine the physical disk space requirements?
It'd probably be easier to discuss this with a concrete example in hand.
How about you give us your info --- specific column datatypes, indexes
to be created, estimated update rate (so we can guess how many dead
tuples you might have at any given time).
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-04-26 15:28:53 | Re: I am now Linux and PostgreSQL user, have a question |
Previous Message | Peter Eisentraut | 2001-04-26 15:24:31 | Re: How to estimate disk space requirements? |