Обсуждение: 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
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?
On Wed, Jun 07, 2006 at 12:43:59PM -0400, mcelroy, tim wrote: > 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. If you're on 8.1.x, see also \df pg_*size* -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461