count(*) tooks much time... but with the where clause we can make this to use indexing,... what where clause we can use??
Am using postgres 7.4 in Debian OS with 1 GB RAM, am having a table with nearly 50 lakh records, it has more than 15 columns, i want to count how many records are there, it is taking nearly 17 seconds to do that... i know that to get a approximate count we can use SELECT reltuples FROM pg_class where relname = TABLENAME; but this give approximate count, and i require exact count...