This is very similar with my problem:
http://postgresql.1045698.n5.nabble.com/index-choosing-problem-td5567320.html
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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
On Tue, May 1, 2012 at 12:17 AM, 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
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, o
