Re: growth of a postgresql database

From: "mcelroy, tim" <tim(dot)mcelroy(at)bostonstock(dot)com>
To: 'Pierre LEBRECH' <pierre(dot)lebrech(at)laposte(dot)net>, pgsql-admin(at)postgresql(dot)org
Subject: Re: growth of a postgresql database
Date: 2006-06-07 16:43:59
Message-ID: 9765373733A7DF4681B12225D2FC44050D6D99@bosexprod001.bostonstock.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Pierre LEBRECH
Sent: Wednesday, June 07, 2006 6:22 AM
To: pgsql-admin(at)postgresql(dot)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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2006-06-07 16:51:08 Re: pg_dumpall 8.1.4 large objects error
Previous Message Scott Marlowe 2006-06-07 14:23:59 Re: Standalone Postgres