index usage makes problem

Поиск
Список
Период
Сортировка
От sathiya psql
Тема index usage makes problem
Дата
Msg-id f966c2ee0803060016j59b52fceq29225bc54a762537@mail.gmail.com
обсуждение исходный текст
Список pgsql-performance
I had 50 lakh records in my table...

while counting that am using that row in where condition... which makes problem, cpu is waiting for device...

Debian OS, postresql 7.4, 50 lakh records.

Query is

EXPLAIN ANALYZE select count(call_id) from call_log where call_id > 1;

while seeing the top, cpu is waiting for i/o, and without this call_id condition if i do
       EXPLAIN ANALYZE select count(oid) from call_log where oid > 1;
it executed in 21 seconds....

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

Предыдущее
От: Theo Kramer
Дата:
Сообщение: Re: oid...any optimizations
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: count * performance issue