-----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