X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id CCEC29FA5CE for ; Wed, 7 Jun 2006 19:42:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 90967-06 for ; Wed, 7 Jun 2006 19:41:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 3ED769FA3C0 for ; Wed, 7 Jun 2006 19:41:58 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id A903556489; Wed, 7 Jun 2006 17:41:56 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 7 Jun 2006 17:41:54 -0500 Date: Wed, 7 Jun 2006 17:41:54 -0500 From: "Jim C. Nasby" To: "mcelroy, tim" Cc: 'Pierre LEBRECH' , pgsql-admin@postgresql.org Subject: Re: growth of a postgresql database Message-ID: <20060607224154.GE45331@pervasive.com> References: <9765373733A7DF4681B12225D2FC44050D6D99@bosexprod001.bostonstock.local> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <9765373733A7DF4681B12225D2FC44050D6D99@bosexprod001.bostonstock.local> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060607:tim.mcelroy@bostonstock.com::WOB0GutUwGzHOpoG:0000000000 000000000000000000000000DKgX X-Hashcash: 1:20:060607:pierre.lebrech@laposte.net::sH8Od9pertmwlR1p:00000000000 0000000000000000000000009+VC X-Hashcash: 1:20:060607:pgsql-admin@postgresql.org::nAswnFamPUX69z9d:00000000000 0000000000000000000000008wCc X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/53 X-Sequence-Number: 22015 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