X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CA28BD7F40 for ; Wed, 12 Oct 2005 14:21:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 77934-02 for ; Wed, 12 Oct 2005 17:21:25 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id CC8F8D7E2E for ; Wed, 12 Oct 2005 14:21:25 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j9CHLO8T002742; Wed, 12 Oct 2005 13:21:24 -0400 (EDT) To: emil@baymountain.com Cc: Csaba Nagy , pgsql-performance@postgresql.org Subject: Re: Help tuning postgres In-reply-to: <200510121133.56955.emil@baymountain.com> References: <1129128315.2995.174.camel@coppola.muc.ecircle.de> <200510121112.11486.emil@baymountain.com> <1129130273.2995.177.camel@coppola.muc.ecircle.de> <200510121133.56955.emil@baymountain.com> Comments: In-reply-to Emil Briggs message dated "Wed, 12 Oct 2005 11:33:56 -0400" Date: Wed, 12 Oct 2005 13:21:24 -0400 Message-ID: <2741.1129137684@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 required=5 tests=[AWL=0.006] X-Spam-Level: X-Archive-Number: 200510/214 X-Sequence-Number: 14982 Emil Briggs writes: >> Not yet, the db is in production use and I have to plan for a down-time >> for that... or is it not impacting the activity on the table ? > It will cause some performance hit while you are doing it. It'll also lock out writes on the table until the index is rebuilt, so he does need to schedule downtime. regards, tom lane