Re: growth of a postgresql database - Mailing list pgsql-admin

From mcelroy, tim
Subject Re: growth of a postgresql database
Date
Msg-id 9765373733A7DF4681B12225D2FC44050D6D99@bosexprod001.bostonstock.local
Whole thread Raw
In response to growth of a postgresql database  (Pierre LEBRECH <pierre.lebrech@laposte.net>)
Responses Re: growth of a postgresql database  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin

The contrib/dbsize module will accomplish what you want.  I use release 8.0.1 and it works for me. 

It provides the size of the DB, you could cron a job to take readings at various times and calculate the growth that way.

Tim

 -----Original Message-----
From:   pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]  On Behalf Of Pierre LEBRECH
Sent:   Wednesday, June 07, 2006 6:22 AM
To:     pgsql-admin@postgresql.org
Subject:        [ADMIN] growth of a postgresql database

Hello,

How can we see/calculate the growth of a postgresql database? Is there any tool in postgresql to see the
growth (or size) of one database? If yes, beginning with which release?

Thank you

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Standalone Postgres
Next
From: Jeff Frost
Date:
Subject: Re: pg_dumpall 8.1.4 large objects error