Postgres Pro
Downloads
Home   >   mailing lists

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

From David Teran
Subject Re: select count(*) from anIntColumn where int_value = 0; is very slow
Date
Msg-id ABE76F32-5C96-11D8-B407-000A95A6F0DC@cluster9.com
Whole thread Raw
In response to Re: select count(*) from anIntColumn where int_value = 0; is very slow  ("Rigmor Ukuhe" <rigmor.ukuhe@finestmedia.com>)
Responses Re: select count(*) from anIntColumn where int_value = 0; is very slow
Re: select count(*) from anIntColumn where int_value = 0;
List pgsql-performance
Tree view 
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.

regards David

pgsql-performance by date:

Previous
From: "Rigmor Ukuhe"
Date:
Subject: Re: select count(*) from anIntColumn where int_value = 0; is very slow
Next
From: PC Drew
Date:
Subject: Re: select count(*) from anIntColumn where int_value = 0; is very slow