Received: from svr_web.FNFI (fidel2.logixcom.net [216.0.153.34] (may be
	forged)) by hub.org (8.10.1/8.10.1) with ESMTP id e74HlrG02917
	for <pgsql-general@postgresql.org>; Fri, 4 Aug 2000 13:47:54 -0400 (EDT)
Received: from email.com (KONA [192.168.100.113]) by svr_web.FNFI with SMTP
	(Microsoft Exchange Internet Mail Service Version 5.5.2650.21)
	id QG9NSH58; Fri, 4 Aug 2000 12:49:03 -0500
Message-ID: <398B0292.A16EDF00@email.com>
Date: Fri, 04 Aug 2000 12:51:14 -0500
From: "Jeffrey A. Rhines" <jrhines@email.com>
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-6.1.1 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: Need for rebuilding index after many deletions?
References: <00bf01bffb93$dd3f4a20$d565e2c1@vs>
	<20000804162632.A2137@feivel.credativ.de>
	<398AE87D.8D1A913@fa.disney.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200008/88

If you're worried about performance, a vacuum should do the trick,
right?

Jeff

Patrick Robin wrote:
> 
> Hi all,
> 
>    With Postgres 6.5.2,  if a table has undergone several row deletions,
> does it make sense/ is it needed  to rebuild the index?  Would this be
> accomplished by
> dropping it and then recreating it?
> 
> Thanks
> 
> Patrick
> 
> --
> ________________________________________
> Patrick Robin
> patrickr@fa.disney.com
> Walt Disney Feature Animation
> 500 South Buena Vista Street
> Burbank,California 91521-4817