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

On Wed, 11 Feb 2004, David Teran wrote:

> Hi,
>
> > 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...