Message-ID: <4FA28299.1080805@kc8onw.net>
Date: Thu, 03 May 2012 09:05:29 -0400
From: Jonathan <jonathan@kc8onw.net>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
To: pgsql-performance@postgresql.org, jturmel@gmail.com
Subject: Re: Query got slow from 9.0 to 9.1 upgrade
References: <A0211EA5A93846FE9F6504F8676905ED@gmail.com>
In-Reply-To: <A0211EA5A93846FE9F6504F8676905ED@gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

On 4/30/2012 5:17 PM, Josh Turmel wrote:
> We just upgraded from 9.0 to 9.1, we're using the same server
> configuration, that has been confirmed 3 or 4 times over. Any help would
> be appreciated. If I remove the "ORDER BY" it gets fast again because it
> goes back to using the user_id index, if I remove the LIMIT/OFFSET it
> gets fast again, obviously I need both of those, but that was just to
> test and see what would happen.

I had this problem as well and ended up working around it by having the
application cache the highest seen user_id and send that back to the
server which uses it in a where clause.  This way I had just the LIMIT
and was able to remove the OFFSET and things ran great.  I don't know
how feasible it is for you to change things application side but it
worked well for me.

Jonathan