Re: Query does not use index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Hampl <Martin(dot)Hampl(at)gmx(dot)de>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Query does not use index
Date: 2004-04-29 23:32:51
Message-ID: 18077.1083281571@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Martin Hampl <Martin(dot)Hampl(at)gmx(dot)de> writes:
> It would be very nice, if someone could have a look at the query I'm
> trying to optimize. At the moment, I don't understand PostgreSQL's
> behaviour and are stuck. Thanks a lot in advance.

Did you ANALYZE these tables? Also, please post EXPLAIN ANALYZE not
just EXPLAIN when complaining about bad plans. Since the essence of
your complaint is that the planner's estimates are wrong, showing us
only estimates and not reality makes it hard to give constructive
suggestions ...

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Martin Hampl 2004-04-30 06:01:39 Re: Query does not use index
Previous Message Martin Hampl 2004-04-29 19:34:52 Query does not use index