On 6-Mar-08, at 1:43 AM, sathiya psql wrote:
is there any way to explicitly force the postgres to use index scan
If you want to count all the rows in the table there is only one way
to do it (without keeping track yourself with a trigger ); a seq scan.
An index will not help you.
The only thing that is going to help you is really fast disks, and
more memory, and you should consider moving to 8.3 for all the other
performance benefits.
Dave
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-performance
