Is your int_value data type int4? If not then use "... from job_property
where int_value = '0'"
Indexes are used only if datatypes matches.
tried those variations already. Strange enough, after dropping and recreating the index everything worked fine.
Has that table been updated a lot in its life? If so, it may have had a problem with index bloat...
Try creating a partial index: create index blah on tablw where int_value=0;
Chris
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
