Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 3379A1337BD7 for ; Mon, 11 Apr 2011 14:25:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 96710-09 for ; Mon, 11 Apr 2011 17:25:11 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gw.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by mail.postgresql.org (Postfix) with ESMTP id DFA1F1337BD5 for ; Mon, 11 Apr 2011 14:25:10 -0300 (ADT) Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Mon, 11 Apr 2011 12:25:10 -0500 Message-Id: <4DA2F31C020000250003C665@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.1 Date: Mon, 11 Apr 2011 12:25:00 -0500 From: "Kevin Grittner" To: "Gerhard Hintermayer" , "pgsql-admin" Subject: Re: Re: multiple hot standby streaming replication scenario with "rotating" the primary server References: <4DA2E174020000250003C650@gw.wicourts.gov> In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.409 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: ** X-Archive-Number: 201104/88 X-Sequence-Number: 37269 Gerhard Hintermayer wrote: > Because tests & docs say so: > http://www.postgresql.org/docs/9.0/static/continuous-archiving.html#CONTINUOUS-ARCHIVING-CAVEATS I asked because I didn't remember any mention of hashed indexes. I still don't know for sure that you have any, much less that you have so many that it makes sense to reindex the entire database. Or are you saying you've seen a problem with indexes of other types? -Kevin