index usage makes problem

------=_Part_3738_4682413.1204791373563
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_3738_4682413.1204791373563
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I had 50 lakh records in my table...<br><br>while counting that am using
that row in where condition... which makes problem, cpu is waiting for
device...<br><br>Debian OS, postresql 7.4, 50 lakh records.<br><br>Query
is<br>
<br>EXPLAIN ANALYZE select count(call_id) from call_log where call_id &gt;
1;<br><br>while seeing the top, cpu is waiting for i/o, and without this
call_id condition if i do <br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; EXPLAIN
ANALYZE select count(oid) from call_log where oid &gt; 1;<br>
it executed in 21 seconds....<br><br>

------=_Part_3738_4682413.1204791373563--