sathiya psql wrote:
> 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,
Looks suspiciously like a question asked yesterday:
http://archives.postgresql.org/pgsql-performance/2008-03/msg00068.php
--
Postgresql & php tutorials
http://www.designmagick.com/
