Estimating Database Disk Space

Поиск
Список
Период
Сортировка
От Richard A Lough
Тема Estimating Database Disk Space
Дата
Msg-id 3C95F36E.3D9FACC4@dnet.co.uk
обсуждение исходный текст
Ответы Re: Estimating Database Disk Space  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi All,

I'm running postgres.7.1.3-7

I'm concerned at the steady growth of disk space taken up by my
postgres.
I have three databases, each of which take up about 2+ MB when dumped.
I have tried deleting one database and re-installing. This suggests that
about 38Mb of disk space is taken up by each database. I suspect that if
postgres were deleted entirely, about 250 MB would be freed.

The FAQ suggests that about 7MB might be taken up by one database when
copied from a file into postgres. Other posts suggest that xlog might
add a further 20MB as an overhead. Indexes are mentioned elsewhere, but
without any means of estimating what their size should be.

Do the above figures seem sensible? Is the required disk space likely
to grow in proportion to the data, or is there an overhead of about
60MB of disk space needed to run each database?

TIA

Richard A Lough

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

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: Excluding null values
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Estimating Database Disk Space