Re:

On Tue, 2003-02-11 at 08:10, greg(at)turnstep(dot)com wrote:
> -----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:

However the original poster suggested there would ultimately be 200,000
or more rows in the table.

Cheers,
Andrew.
>
> http://archives.postgresql.org/pgsql-novice/2003-02/msg00075.php
>
> - --
> Greg Sabino Mullane greg(at)turnstep(dot)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-----
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267
Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------