-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> i need to get a row count on a large table. it appears that
>   select count(*) from <table>;
> always does a table scan, whether i have an index or not, and that is too 
> slow.


http://www.gtsm.com/oscon2003/findrows.html


- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200308060951
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/MQgmvJuQZxSWSsgRAkFDAJwPz5C7OljCg4TYqxvw4/WjLr8TlgCgovtS
xQPuL/l+QCPgmwVDeX0yocM=
=XtnA
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to