Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 3FF769FA104; Wed, 21 Mar 2007 14:26:02 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 42397-10; Wed, 21 Mar 2007 14:25:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc3-s35.bay0.hotmail.com (bay0-omc3-s35.bay0.hotmail.com [65.54.246.235]) by postgresql.org (Postfix) with ESMTP id 38BFC9FA0C0; Wed, 21 Mar 2007 14:25:55 -0300 (ADT) Received: from hotmail.com ([65.55.136.119]) by bay0-omc3-s35.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Wed, 21 Mar 2007 10:25:53 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 21 Mar 2007 10:25:53 -0700 Message-ID: Received: from 65.55.136.123 by by131fd.bay131.hotmail.msn.com with HTTP; Wed, 21 Mar 2007 17:25:51 GMT X-Originating-IP: [67.116.31.14] X-Originating-Email: [skarthi98@hotmail.com] X-Sender: skarthi98@hotmail.com In-Reply-To: <20070321033244.GA39959@winnie.fuhr.org> From: "Karthikeyan Sundaram" To: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Subject: growth of the database Date: Wed, 21 Mar 2007 10:25:51 -0700 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 21 Mar 2007 17:25:53.0590 (UTC) FILETIME=[FA602D60:01C76BDD] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/147 X-Sequence-Number: 24971 Hi, Our database is growing fast. I want to create a cronjob that should tell me what is the current size of the database on each day. How can I find this from the database? Is there any pre-written scripts written by somebody to share? Regards skarthi _________________________________________________________________ Live Search Maps – find all the local information you need, right when you need it. http://maps.live.com/?icid=hmtag2&FORM=MGAC01