Re: db size reporting - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: db size reporting
Date
Msg-id 434DC2A4.80904@commandprompt.com
Whole thread Raw
In response to db size reporting  (jeff sacksteder <jsacksteder@gmail.com>)
List pgsql-general
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/


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: db size reporting
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [pgsql-advocacy] Oracle buys Innobase