Re: How to estimate disk space requirements?

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

In response to

Browse pgsql-general by date

  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?