Re: How to estimate disk space requirements? - Mailing list pgsql-general

From Tom Lane
Subject Re: How to estimate disk space requirements?
Date
Msg-id 16320.988298861@sss.pgh.pa.us
Whole thread Raw
In response to How to estimate disk space requirements?  (Bryan Field-Elliot <bryan_lists@netmeme.org>)
List pgsql-general
Bryan Field-Elliot <bryan_lists@netmeme.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

pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: Re: Need for newbie friendly docs (was Newbie struggling...)
Next
From: Justin Clift
Date:
Subject: Re: Re: Need for newbie friendly docs (was Newbie struggling...)