sathiya psql wrote:
EXPLAIN ANALYZE SELECT count(*) from call_log_in_ram ;
And your usual query is:
SELECT count(*) from call_log_in_ram;
?
If so, you should definitely build a summary table maintained by a
trigger to track the row count. That's VERY well explained in the
mailing list archives. This was suggested to you very early on in the
discussion.
If you have problems with other queries, how about showing EXPLAIN
ANALYZE for the other queries you're having problems with?
--
Craig Ringer
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
