Received: from mail.disney.com (mail.disney.com [204.128.192.15]) by hub.org (8.10.1/8.10.1) with ESMTP id e74G07G75392 for ; Fri, 4 Aug 2000 12:00:07 -0400 (EDT) Received: from pain10.corp.disney.com (root@pain10.corp.disney.com [153.7.110.100]) by mail.disney.com (Switch-2.0.1/Switch-2.0.1) with SMTP id e74G06129005 for ; Fri, 4 Aug 2000 09:00:06 -0700 (PDT) Received: from louie.fa.disney.com by pain.corp.disney.com with ESMTP for pgsql-general@postgresql.org; Fri, 4 Aug 2000 09:00:25 -0700 Received: from hermes.fas.fa.disney.com (hermes.fas.fa.disney.com [153.7.113.1]) by louie.fa.disney.com (8.9.2/8.9.2) with ESMTP id IAA08778 for ; Fri, 4 Aug 2000 08:59:58 -0700 (PDT) (envelope-from Patrick.Robin@disney.com) Received: from [153.7.112.235] by hermes.fas.fa.disney.com with ESMTP; Fri, 4 Aug 2000 08:59:58 -0700 Message-Id: <398AE87D.8D1A913@fa.disney.com> Date: Fri, 04 Aug 2000 08:59:58 -0700 From: Patrick Robin X-Mailer: Mozilla 4.7 [en] (X11; U; IRIX 6.2 IP22) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-general@postgresql.org CC: Stephen Bowline Subject: Need for rebuilding index after many deletions? References: <00bf01bffb93$dd3f4a20$d565e2c1@vs> <20000804162632.A2137@feivel.credativ.de> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200008/86 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