Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1568F632A17 for ; Wed, 31 Mar 2010 18:47:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 30680-03 for ; Wed, 31 Mar 2010 21:47:24 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-pv0-f174.google.com (mail-pv0-f174.google.com [74.125.83.174]) by mail.postgresql.org (Postfix) with ESMTP id 63C84632613 for ; Wed, 31 Mar 2010 18:47:24 -0300 (ADT) Received: by pva18 with SMTP id 18so78403pva.19 for ; Wed, 31 Mar 2010 14:47:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:received:message-id:subject:from:to:cc:content-type; bh=Xwndhm5lgVfHfuiFICHEY7M56dRxGLrSqUYMx4hbvZ4=; b=BFOvZadQeRRT77peWMTSoiXjhb7HmgVOPbJOpgngd84W5jlZSatmAXYKuljmeWihKx g+DpHLGFPVUHaiL3t/nHRCQnQCBYg4GzmS6wGdYLZnIBoiMx35jsU+LRYMQiA7jxo+bN jn3GpmjkCfiwzB8AYkYnG0bmoZK/S0mxv7xNY= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=NYKMubAlnnnNxRR/ZmgMbqKwAXQobpk2q90xpQkD+cqAmnljyDjRKfvHprYLSe3det RjTwlpoS7KoCufcuREJRi2C6tTA3IgAcHkppWi/ouAttQ7wDFYT9DahsBYzQyOTp4mLZ FVgurj913xrj9uS211MurRSLvnB9aZfXJl3Gg= MIME-Version: 1.0 Received: by 10.140.178.4 with HTTP; Wed, 31 Mar 2010 14:47:22 -0700 (PDT) In-Reply-To: <4BB37AE402000025000302C5@gw.wicourts.gov> References: <4BB3722F02000025000302BF@gw.wicourts.gov> <4BB37AE402000025000302C5@gw.wicourts.gov> Date: Thu, 1 Apr 2010 03:17:22 +0530 Received: by 10.141.13.7 with SMTP id q7mr4266685rvi.67.1270072042702; Wed, 31 Mar 2010 14:47:22 -0700 (PDT) Message-ID: Subject: Re: How to fast the REINDEX From: raghavendra t To: Kevin Grittner Cc: pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=000e0cd11ae0f1c80904831fb05b X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5 tests=BAYES_20=-0.74, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/419 X-Sequence-Number: 38244 --000e0cd11ae0f1c80904831fb05b Content-Type: text/plain; charset=ISO-8859-1 > > If this is a one-time fix for a corrupted index, did you look at > CREATE INDEX CONCURRENTLY? You could avoid any down time while you > fix things up. > Using CREATE INDEX CONCURRENTLY will avoid the exclusive locks on the table, but my question is, how to get a performance on the existing indexes. You mean to say , drop the existing indexes and create the index with CONCURRENTLY. Does this give the performance back. Regards Raghavendra On Thu, Apr 1, 2010 at 3:10 AM, Kevin Grittner wrote: > raghavendra t wrote: > > > overcome with a corrupted index. > > If this is a one-time fix for a corrupted index, did you look at > CREATE INDEX CONCURRENTLY? You could avoid any down time while you > fix things up. > > http://www.postgresql.org/docs/8.4/interactive/sql-createindex.html > > -Kevin > --000e0cd11ae0f1c80904831fb05b Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
If this is a one-time fix for a = corrupted index, did you look at
CREATE INDEX CONCURRENTLY? =A0You could= avoid any down time while you
fix things up.
Using CREATE INDEX CONCURRENTLY will avoid the exclusive locks on the = table, but my question is, how=A0to get a performance on the existing index= es. You mean to say , drop the existing indexes and create the index with C= ONCURRENTLY. Does this give the performance back.
=A0
Regards
Raghavendra
=A0
=A0
On Thu, Apr 1, 2010 at 3:10 AM, Kevin Grittner <= span dir=3D"ltr"><Kevin.G= rittner@wicourts.gov> wrote:
raghavendra t <raagavendra.rao@gmail.com> wrote:

> overcome with a corrupted index.

If thi= s is a one-time fix for a corrupted index, did you look at
CREATE INDEX = CONCURRENTLY? =A0You could avoid any down time while you
fix things up.<= br>
http://www.postgresql.org/docs/8.4/interactive/s= ql-createindex.html

-Kevin

--000e0cd11ae0f1c80904831fb05b--