From: sathiya psql <sathiya.psql@gmail.com>
To: pgsql-performance@postgresql.org
Subject: index usage makes problem
Date: Thu, 6 Mar 2008 13:46:13 +0530
Message-ID: <f966c2ee0803060016j59b52fceq29225bc54a762537@mail.gmail.com> (raw)
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....
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sathiya.psql@gmail.com
Subject: Re: index usage makes problem
In-Reply-To: <f966c2ee0803060016j59b52fceq29225bc54a762537@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox