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,
On Tue, May 1, 2012 at 12:17 AM, Josh Turmel jtur...@gmail.com 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
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
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