Re: db size reporting

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
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:12:52
Message-ID: 434DC2A4.80904@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-10-13 02:17:35 Re: [pgsql-advocacy] Oracle buys Innobase
Previous Message Tom Lane 2005-10-13 02:08:05 Re: db size reporting