Estimating Database Disk Space

From: Richard A Lough <ralough(dot)ced(at)dnet(dot)co(dot)uk>
To: PostgreSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Estimating Database Disk Space
Date: 2002-03-18 14:02:22
Message-ID: 3C95F36E.3D9FACC4@dnet.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-03-18 15:43:19 Re: Estimating Database Disk Space
Previous Message Josh Berkus 2002-03-17 22:40:19 Re: Excluding null values