Re: Strange query plan - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Strange query plan
Date
Msg-id 200808141430.37967.peter_e@gmx.net
Whole thread Raw
In response to Strange query plan  ("Dmitry Teslenko" <dteslenko@gmail.com>)
Responses Re: Strange query plan
List pgsql-general
Am Thursday, 14. August 2008 schrieb Dmitry Teslenko:
> SELECT SUM(...) FROM table1 WHERE field3 = 'ABC' AND field1 <> 1
>     GROUP BY field2
>
> And planner picks up a sequential scan of a table. Why does he?

Presumably because it thinks it is the best plan, and I see no reason to doubt
that outright.  You might get better performance with an index on field3.

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Postgres 8.3 is not using indexes
Next
From: Gregory Stark
Date:
Subject: Re: Postgres 8.3 is not using indexes