------=_Part_3466_2902788.1204782181940
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
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...
------=_Part_3466_2902788.1204782181940
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
count(*) tooks much time...<br><div class="gmail_quote"><br>but with the
where clause we can make this to use indexing,... what where clause we can
use??<br><br>Am using postgres 7.4 in Debian OS with 1 GB RAM, <br><br>am
having a table with nearly 50 lakh records, <br>
<br>it has more than 15 columns, i want to count how many records are
there, it is taking nearly 17 seconds to do that...<br><br>i know that to
get a approximate count we can
use<br> SELECT reltuples
FROM pg_class where relname = TABLENAME;<br>
<br>but this give approximate count, and i require exact count...<br>
</div><br>
------=_Part_3466_2902788.1204782181940--
|
