Re: Estimating Database Disk Space

Tom Lane wrote:
> 
> Richard A Lough  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