Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5AD8F1337B8B for ; Tue, 30 Nov 2010 14:54:00 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 49697-09 for ; Tue, 30 Nov 2010 18:53:53 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id D5A601337BB9 for ; Tue, 30 Nov 2010 14:53:52 -0400 (AST) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Tue, 30 Nov 2010 12:53:52 -0600 Message-Id: <4CF4F3D80200002500037F9E@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Tue, 30 Nov 2010 12:53:44 -0600 From: "Kevin Grittner" To: "Shridhar Polas" , "'Kenneth Marshall'" Cc: Subject: Re: Space occupied by Postgres index. References: <00b901cb90b3$ca9ddc40$5fd994c0$@gmail.com> <20101130172841.GK19162@aart.is.rice.edu> <00c301cb90b5$f54b6370$dfe22a50$@gmail.com> In-Reply-To: <00c301cb90b5$f54b6370$dfe22a50$@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/262 X-Sequence-Number: 36228 "Shridhar Polas" wrote: > In my test setup I found that the disk space consumed by Postgers > is not getting declined even after deleting records from tables, > if I do not perform VACUUM FULL and REINDEX. True, but if you expect the tables to grow again it's generally better to leave the space allocated to PostgreSQL than to make it give it back up to the OS for the moment and have to go ask for it again later. If you don't expect PostgreSQL to need the space again and you want to release it back to the OS, prior to release 9.0 it is usually better to use CLUSTER than to use VACUUM FULL and REINDEX. -Kevin