Re: Estimating Database Disk Space - Mailing list pgsql-novice

From Richard A Lough
Subject Re: Estimating Database Disk Space
Date
Msg-id 3C963734.145AD80D@dnet.co.uk
Whole thread Raw
In response to Estimating Database Disk Space  (Richard A Lough <ralough.ced@dnet.co.uk>)
Responses Re: Estimating Database Disk Space
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Estimating Database Disk Space
Next
From: Richard A Lough
Date:
Subject: pg_restore has error message 7