Re: How to estimate disk space requirements?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
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:24:31
Message-ID: Pine.LNX.4.30.0104261723580.758-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bryan Field-Elliot 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?

There is some info in the FAQ. You should estimate roughly five times the
size of the data in flat text.

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-26 15:27:41 Re: How to estimate disk space requirements?
Previous Message Peter Eisentraut 2001-04-26 15:22:55 Re: using POSTGRES in a network