Re: db size reporting

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: jeff sacksteder <jsacksteder(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: db size reporting
Date: 2005-10-13 02:08:05
Message-ID: 16483.1129169285@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

jeff sacksteder <jsacksteder(at)gmail(dot)com> writes:
> I'm going to be working with some rather large datasets and I want to
> evaluate the effects of normalization/denormalization on disk space. Is
> there a simple way to find the size on disk of a specific database?

Look into the functions offered by contrib/dbsize. Or read
http://developer.postgresql.org/docs/postgres/storage.html
and use du by hand ;-)

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-10-13 02:12:52 Re: db size reporting
Previous Message Bruce Momjian 2005-10-13 02:02:34 Re: [pgsql-advocacy] Oracle buys Innobase