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

Поиск
Список
Период
Сортировка
От David Teran
Тема Re: select count(*) from anIntColumn where int_value = 0; is very slow
Дата
Msg-id ABE76F32-5C96-11D8-B407-000A95A6F0DC@cluster9.com
обсуждение исходный текст
Ответ на Re: select count(*) from anIntColumn where int_value = 0; is very slow  ("Rigmor Ukuhe" <rigmor.ukuhe@finestmedia.com>)
Ответы Re: select count(*) from anIntColumn where int_value = 0; is very slow  (PC Drew <drewpc@ibsncentral.com>)
Re: select count(*) from anIntColumn where int_value = 0;  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Rigmor Ukuhe"
Дата:
Сообщение: Re: select count(*) from anIntColumn where int_value = 0; is very slow
Следующее
От: PC Drew
Дата:
Сообщение: Re: select count(*) from anIntColumn where int_value = 0; is very slow