Re: select count(*) from anIntColumn where int_value = 0; is very slow

From: David Teran <david(dot)teran(at)cluster9(dot)com>
To: "Rigmor Ukuhe" <rigmor(dot)ukuhe(at)finestmedia(dot)com>
Cc: "PgSQL Performance ML" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: select count(*) from anIntColumn where int_value = 0; is very slow
Date: 2004-02-11 13:32:00
Message-ID: ABE76F32-5C96-11D8-B407-000A95A6F0DC@cluster9.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message PC Drew 2004-02-11 13:42:19 Re: select count(*) from anIntColumn where int_value = 0; is very slow
Previous Message Rigmor Ukuhe 2004-02-11 13:12:00 Re: select count(*) from anIntColumn where int_value = 0; is very slow