Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 56ADC632C7A
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 31 Mar 2010 17:51:39 -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 21383-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Wed, 31 Mar 2010 20:51:28 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-pw0-f46.google.com (mail-pw0-f46.google.com
	[209.85.160.46])
	by mail.postgresql.org (Postfix) with ESMTP id BF6906327FC
	for <pgsql-performance@postgresql.org>;
	Wed, 31 Mar 2010 17:51:28 -0300 (ADT)
Received: by pwi5 with SMTP id 5so539312pwi.19
	for <pgsql-performance@postgresql.org>;
	Wed, 31 Mar 2010 13:51:27 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:received:message-id
	:subject:from:to:content-type;
	bh=2pc2pTTZlJ0I+OfAekB+AR8Gfbz5fWBR1UpQMz/d5R0=;
	b=DcEsZZSSkDUNrt29NYyOSpgBeexq2vN4EKqH1q+eRwdj9KMTgmlg+VRXK7SYMPV3Iu
	krfR/mdD2AbD5Vc1zj1SGfsjFHecZGCNekc1YVxeXyNjgU5Ccs2iN82it45Hyi7uuagc
	C+WVXGkEQ9cJmg+wuLkS+/cewP0z4ea8i1knk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=hhC++yqoa0LaeOtYp+oTxb+3k7PsCVV2kVy/BvltIXtGIU5iBEnmtbIBx1D5xHMrkq
	EyB1CB3K/TkXuK6Cph/F7708PehlXxa+zSrN0sU1vlXaYxcp6px/IWIyZQCR0C5v17wx
	16+GELcAMwWRvGUebrxrr5xReyxXPMIwzPct4=
MIME-Version: 1.0
Received: by 10.140.178.4 with HTTP; Wed, 31 Mar 2010 13:51:26 -0700 (PDT)
Date: Thu, 1 Apr 2010 02:21:26 +0530
Received: by 10.141.89.8 with SMTP id r8mr6540549rvl.32.1270068686766;
 Wed, 31
	Mar 2010 13:51:26 -0700 (PDT)
Message-ID: <p2ubc7de5a31003311351p83987eedpbb86727ab9fa9ca3@mail.gmail.com>
Subject: How to fast the REINDEX
From: raghavendra t <raagavendra.rao@gmail.com>
To: pgsql-performance@postgresql.org
Content-Type: multipart/alternative; boundary=000e0cd138e0ea455c04831ee863
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.002 tagged_above=-10 required=5
	tests=BAYES_50=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/415
X-Sequence-Number: 38240

--000e0cd138e0ea455c04831ee863
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

I have a table with 40GB size, it has few indexes on it. When i try to
REINDEX on the table, its take a long time. I tried increasing the
maintenance_work_mem, but still i havnt find a satisfying result.

Questions
=======
1. What are the parameters will effect, when issuing the REINDEX command
2. Best possible way to increase the spead of the REINDEX

Thanks in Advance

Regards
Raghavendra

--000e0cd138e0ea455c04831ee863
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div>Hi All,</div>
<div>=A0</div>
<div>I have a table=A0with 40GB size, it has few indexes on it. When i try =
to REINDEX on the table, its take a long time. I tried=A0increasing the mai=
ntenance_work_mem, but still i havnt find a satisfying result. </div>
<div>=A0</div>
<div>Questions</div>
<div>=3D=3D=3D=3D=3D=3D=3D</div>
<div>1. What are the parameters will effect, when issuing the REINDEX comma=
nd</div>
<div>2. Best possible way to increase the spead of the REINDEX</div>
<div>=A0</div>
<div>Thanks in Advance</div>
<div>=A0</div>
<div>Regards</div>
<div>Raghavendra</div>
<div>=A0</div>

--000e0cd138e0ea455c04831ee863--