Re: Problems with non use of indexes

From: Tyler Durden <tylersticky(at)gmail(dot)com>
To: Tomas Vondra <tv(at)fuzzy(dot)cz>
Cc: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problems with non use of indexes
Date: 2012-03-02 13:34:13
Message-ID: CAL0cWDR6ZXwgS5vygV=4p1JtU5yjptLXoqLPJCMymoNuwPQj6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Thanks!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2012-03-02 14:23:27 Re: Problems with non use of indexes
Previous Message Tomas Vondra 2012-03-02 12:55:42 Re: Problems with non use of indexes