Re: Problems with non use of indexes - Mailing list pgsql-general

From Tomas Vondra
Subject Re: Problems with non use of indexes
Date
Msg-id 574fe78192bdacccb2006a250aaff568.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: Problems with non use of indexes  (Tyler Durden <tylersticky@gmail.com>)
Responses Re: Problems with non use of indexes
List pgsql-general
On 2 Březen 2012, 13:45, Tyler Durden wrote:
>>
> Yes, but if I remove *U0."user_id" = 1 *will use the index:

Which PostgreSQL version is that? Post EXPLAIN ANALYZE output for all
three queries, not just EXPLAIN. And use explain.depesz.com if possible,
it's much more readable.

kind regards
Tomas



pgsql-general by date:

Previous
From: Tyler Durden
Date:
Subject: Re: Problems with non use of indexes
Next
From: Tyler Durden
Date:
Subject: Re: Problems with non use of indexes