Re: How to estimate disk space requirements?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: How to estimate disk space requirements?
Дата
Msg-id Pine.LNX.4.30.0104261723580.758-100000@peter.localdomain
обсуждение исходный текст
Ответ на How to estimate disk space requirements?  (Bryan Field-Elliot <bryan_lists@netmeme.org>)
Список 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@gmx.net   http://funkturm.homeip.net/~peter


В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Classes of returned rows
Следующее
От: Marko Kreen
Дата:
Сообщение: Re: crypt(table.field) ?