Re: select count(*) from anIntColumn where int_value = - Mailing list pgsql-performance

>>>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