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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general