Postgres Pro
Downloads
Home   >   mailing lists

Thread: db size reporting

db size reporting

From
jeff sacksteder
Date:
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? To do so with the operating system is rather crude, since it know nothing about what proportion of the cluster area is allocated for each database.

Re: db size reporting

From
Tom Lane
Date:
jeff sacksteder <jsacksteder@gmail.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

Re: db size reporting

From
"Joshua D. Drake"
Date:
jeff sacksteder wrote:

> 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?
> To do so with the operating system is rather crude, since it know
> nothing about what proportion of the cluster area is allocated for
> each database.

look for the dbsize utils in the contrib.

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/