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 14:23:27
Message-ID: 990057fa55712c2b483f5998649ea8a1.squirrel@sq.gransy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2 Březen 2012, 14:34, Tyler Durden wrote:
> On Fri, Mar 2, 2012 at 12:55 PM, Tomas Vondra <tv(at)fuzzy(dot)cz> wrote:
>
>> 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
>>
>
> I'm using PostgreSQL 8.4.2 and you can find the EXPLAIN ANALYSE VERBOSE in
> http://explain.depesz.com/s/hk2

For all three queries, please.

Tomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tyler Durden 2012-03-02 14:55:28 Re: Problems with non use of indexes
Previous Message Tyler Durden 2012-03-02 13:34:13 Re: Problems with non use of indexes