Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 01DF2632C7A for ; Wed, 31 Mar 2010 19:25:29 -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 08222-05 for ; Wed, 31 Mar 2010 22:25:12 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f216.google.com (mail-bw0-f216.google.com [209.85.218.216]) by mail.postgresql.org (Postfix) with ESMTP id 2BEC5632513 for ; Wed, 31 Mar 2010 19:25:17 -0300 (ADT) Received: by bwz8 with SMTP id 8so464490bwz.3 for ; Wed, 31 Mar 2010 15:25:16 -0700 (PDT) MIME-Version: 1.0 Received: by 10.204.56.81 with HTTP; Wed, 31 Mar 2010 15:25:01 -0700 (PDT) In-Reply-To: References: <4BB3722F02000025000302BF@gw.wicourts.gov> From: Jaime Casanova Date: Wed, 31 Mar 2010 18:25:01 -0400 Received: by 10.204.161.199 with SMTP id s7mr303304bkx.9.1270074316204; Wed, 31 Mar 2010 15:25:16 -0700 (PDT) Message-ID: Subject: Re: How to fast the REINDEX To: raghavendra t Cc: Kevin Grittner , pgsql-performance@postgresql.org Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.514 tagged_above=-10 required=5 tests=AWL=-0.515, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/423 X-Sequence-Number: 38248 On Wed, Mar 31, 2010 at 5:33 PM, raghavendra t wrote: > >>>Why are you doing that? > Our table face lot of updates and deletes in a day, so we prefer reindex = to > update the indexes as well overcome with a corrupted index. > do you have a corrupted index? if not, there is nothing to do... REINDEX is not a mantenance task on postgres --=20 Atentamente, Jaime Casanova Soporte y capacitaci=C3=B3n de PostgreSQL Asesor=C3=ADa y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157