Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 55614633F71 for ; Thu, 1 Apr 2010 08:37:49 -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 90052-05-6 for ; Thu, 1 Apr 2010 11:37:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by mail.postgresql.org (Postfix) with ESMTP id 8ABEE632814 for ; Thu, 1 Apr 2010 08:36:59 -0300 (ADT) Received: from [75.236.174.227] (227.sub-75-236-174.myvzw.com [75.236.174.227]) by mrelayeu.kundenserver.de (node=mreu1) with ESMTP (Nemesis) id 0MhgyF-1OBPZb1ZS7-00MSRt; Thu, 01 Apr 2010 13:36:57 +0200 Message-ID: <4BB48556.2030406@2ndquadrant.com> Date: Thu, 01 Apr 2010 07:36:54 -0400 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: raghavendra t CC: pgsql-performance@postgresql.org Subject: Re: How to fast the REINDEX References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V01U2FsdGVkX19KsYi167on3q0pFsb8/hsAayrBfJXm9tFlqOG jL9+2NT7Uu+zwlNpoQftGR5ZdGE6lXTnyDQBGyPVe9fClaWkCY dpQE4Yx8KAPjyLglVDOLm6rilfrPnfj X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.185 tagged_above=-10 required=5 tests=BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 201004/3 X-Sequence-Number: 38253 raghavendra t wrote: > 1. What are the parameters will effect, when issuing the REINDEX command > 2. Best possible way to increase the spead of the REINDEX If you haven't done the usual general tuning on your server, that might help. http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server is an introduction. If increasing maintainance_work_mem alone doesn't help, I'd try increases to checkpoint_segments and then shared_buffers next. Those are the three parameters mostly likely to speed that up. The things already suggested in this thread are still valid though. Needing to REINDEX suggests there may be a problem with your database better addressed by running autovacuum more regularly. -- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@2ndQuadrant.com www.2ndQuadrant.us