Re: Estimating Database Disk Space

Tom Lane wrote:
>
> Richard A Lough <ralough.ced@dnet.co.uk> writes:
> > 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.
>
> A "du" on your $PGDATA directory would give you some facts instead of
> guesses.
>
It seems to have grown a little, du says:
250540     base
32812     pg_xlog
472    global
4    postmaster.pid
4    postmaster.opts
4    PG_VERSION
0    postgresql.conf

Databases, dumped in text format are 3.3MB, 3.3MB and 1.6MB,
though there are be a couple of empty temporary databases
on the system as well.

Thanks for your reply

Richard A Lough