DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:Cc:In-Reply-To:MIME-Version:Content-Type;
	b=mOmeTZxomUFaJ21UYbZHmZ9cmDGX2STikh045o7eKcwYiYvZwyVvFzaKilC7wcf2s4Bj0q3Z8NqKZmvWd28VGCVrcnp1TfUb/rijLeyBRWCJupJ7jWsTWw6g9USkvmcxkmK6wGf7ttJC8+F3ZhIh3s6x6BEqBXCxUAO5CpSJimM=;
References: <1356001615.20304.YahooMailNeo@web125905.mail.ne1.yahoo.com>
	<50D3187D.1060309@usit.uio.no>
Message-ID: <1356041567.95527.YahooMailNeo@web125902.mail.ne1.yahoo.com>
Date: Thu, 20 Dec 2012 14:12:47 -0800 (PST)
From: Greg Williamson <gwilliamson39@yahoo.com>
Reply-To: Greg Williamson <gwilliamson39@yahoo.com>
Subject: Re: Upgrade from 9.1.6 to 9,
 1.7 seems to have caused a major slowdown
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <50D3187D.1060309@usit.uio.no>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Rafael --
<...>


>>  Has anyone else seen anything like this ?
>> 
> 
> Hello
> 
> The release notes for 9.2.2 say this:
> 
> "... However, you may need to perform REINDEX operations to correct
> problems in concurrently-built indexes, as described in the first
> changelog item below....."
> 
> But the 9.1.7 note says nothing about this, even when this version has
> the same patch for 'CREATE INDEX CONCURRENTLY' as 9.2.2
> 
> Why don't you try to reindex the indexes in your database and see it
> this helps?
> 
> regards,
> - -- 
> Rafael Martinez Guerrero


Thanks for the suggestion -- I did indeed a lot of time on checking indexes.

But of course it was not postgres at all, just servers that hadn't dealt well with the brief outage.

The upgraded instance is performing just as expected.

Thanks & sorry for wasting time of the list, wee hours of the morning and a sense of desperation. 


GW


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin