Re: lisp mail archive software

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

John DeSoi <[email protected]> writes:

> I was wondering if OID is implicitly indexed or if you need to add one
> to ensure this is fast with a large number of rows?

stargreen=> explain select * from order_line where oid=233554;
                           QUERY PLAN                           
- ----------------------------------------------------------------
 Seq Scan on order_line  (cost=0.00..16367.73 rows=1 width=212)
   Filter: (oid = 233554::oid)

The latter, it looks like.  Hmm, that surprised me.

Googling for "index on oid postgresql" indicates that other people
seem to be defining indices on the oid already, though.  Mapserver
apparently requires it.


- -dan

- -- 

   http://www.cliki.net/ - Link farm for free CL-on-Unix resources 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/CW1DHDK5ZnWQiRMRAtsvAKDGG44UPoUuaNDmzvMRWfbwMC20TgCfZVQ/
IdzpOHkNWDeofCLtNFSDpxo=
=j20n
-----END PGP SIGNATURE-----