| 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: | Whole Thread | Raw Message | 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? |