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 E778DD96AD for ; Tue, 18 Oct 2005 12:19:22 -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 85104-01 for ; Tue, 18 Oct 2005 15:19:21 +0000 (GMT) Received: from bramble.mmrd.com (bramble.mmrd.com [65.217.53.66]) by svr1.postgresql.org (Postfix) with ESMTP id B73DBD96A5 for ; Tue, 18 Oct 2005 12:19:20 -0300 (ADT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by bramble.mmrd.com (8.12.8/8.12.8) with ESMTP id j9IFiHoJ022967; Tue, 18 Oct 2005 11:44:18 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [10.225.10.110]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id j9IFIid00429; Tue, 18 Oct 2005 11:18:44 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id TWC05D66; Tue, 18 Oct 2005 11:18:41 -0400 Subject: Re: Help tuning postgres From: Robert Treat To: Steve Poe Cc: Tom Lane , pgsql-performance@postgresql.org, Csaba Nagy , emil@baymountain.com In-Reply-To: <1129138325.26659.14.camel@amd64-gentoo-laptop> 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> <2741.1129137684@sss.pgh.pa.us> <1129138325.26659.14.camel@amd64-gentoo-laptop> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 18 Oct 2005 11:18:41 -0400 Message-Id: <1129648722.2022.8.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.028 required=5 tests=[AWL=0.028] X-Spam-Level: X-Archive-Number: 200510/262 X-Sequence-Number: 15030 reindex should be faster, since you're not dumping/reloading the table contents on top of rebuilding the index, you're just rebuilding the index. Robert Treat emdeon Practice Services Alachua, Florida On Wed, 2005-10-12 at 13:32, Steve Poe wrote: > > Would it not be faster to do a dump/reload of the table than reindex or > is it about the same? > > Steve Poe > > On Wed, 2005-10-12 at 13:21 -0400, Tom Lane wrote: > > 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 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to majordomo@postgresql.org so that your > > message can get through to the mailing list cleanly > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL