Re: Problems with non use of indexes

From: "Tomas Vondra" <tv(at)fuzzy(dot)cz>
To: "Tyler Durden" <tylersticky(at)gmail(dot)com>
Cc: "Tomas Vondra" <tv(at)fuzzy(dot)cz>, "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problems with non use of indexes
Date: 2012-03-02 12:55:42
Message-ID: 574fe78192bdacccb2006a250aaff568.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tyler Durden 2012-03-02 13:34:13 Re: Problems with non use of indexes
Previous Message Tyler Durden 2012-03-02 12:45:04 Re: Problems with non use of indexes