Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 445C36324CD
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  4 Apr 2010 23:29:36 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 68088-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  5 Apr 2010 02:29:16 +0000 (UTC)
X-Greylist: delayed 00:07:37.419187 by SQLgrey-1.7.6
Received: from qw-out-2122.google.com (qw-out-2122.google.com [74.125.92.26])
	by mail.postgresql.org (Postfix) with ESMTP id 8B92D6321A8
	for <pgsql-admin@postgresql.org>; Sun,  4 Apr 2010 23:29:25 -0300 (ADT)
Received: by qw-out-2122.google.com with SMTP id 8so1222558qwh.61
	for <pgsql-admin@postgresql.org>; Sun, 04 Apr 2010 19:29:24 -0700 (PDT)
Received: by 10.229.213.140 with SMTP id gw12mr8218689qcb.96.1270434106459;
	Sun, 04 Apr 2010 19:21:46 -0700 (PDT)
Received: from [192.168.1.254] ([121.246.205.20])
	by mx.google.com with ESMTPS id v26sm4565934qce.1.2010.04.04.19.21.44
	(version=TLSv1/SSLv3 cipher=RC4-MD5);
	Sun, 04 Apr 2010 19:21:45 -0700 (PDT)
Message-ID: <4BB94934.3050709@itech7.com>
Date: Mon, 05 Apr 2010 07:51:40 +0530
From: Nilesh Govindarajan <lists@itech7.com>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.9.1.9) Gecko/20100330 Shredder/3.0.4
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Execute VACUUM FULL when DB touches a specific size ?
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.767 tagged_above=-10 required=5 tests=AWL=-0.768,
	BAYES_50=0.001
X-Spam-Level: 
X-Archive-Number: 201004/21
X-Sequence-Number: 34115

Hi,

I wish to execute VACUUM FULL when DB touches a specific size. How to do 
it ?

I'm aware about the caveats of VACUUM FULL.

-- 
Nilesh Govindarajan
Site & Server Administrator
www.itech7.com
मेरा भारत महान !
मम भारत: महत्तम भवतु !