determining database size - Mailing list pgsql-general

From Lee Kindness
Subject determining database size
Date
Msg-id 15550.31193.891286.188798@kelvin.csl.co.uk
Whole thread Raw
In response to determining database size  (Jeff Davis <list-pgsql-general@dynworks.com>)
List pgsql-general
Take a look at dbsize in the contrib directory of the source
distribution - it's a function you add to your DB to get the size of
databases. I don't know how the RPMs handle the contrib stuff, but it
might be available without compiling it yourself.

Nicer than the other ways...

Jeff Davis writes:
 > I would just like to know how to determine the size of a database. The
 > directories inside the data directory are numerical, so I can't associate
 > them with a particular database or table.
 >
 > I would basically just like to create reports so I can determine how fast the
 > disk usage is increasing.

pgsql-general by date:

Previous
From: Curt Sampson
Date:
Subject: Re: Questions on 7.2.1 query plan choices
Next
From: Petr Bravenec
Date:
Subject: Re: SQL question..