-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
> Wouldn't there need to be an index on OID for your query to be fast?
No, the single index on the "date" field is enough. See the EXPLAIN
output from my first post in the original thread:
http://archives.postgresql.org/pgsql-novice/2003-02/msg00075.php
- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200302101404
-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html
iD8DBQE+R/jEvJuQZxSWSsgRAsaYAKDOzKuujdaqkvImutA0nl1/YqVNvgCg+Qk2
lNTYcT/cGyoFKZzd3bVqef4=
=n1Iq
-----END PGP SIGNATURE-----