Re: lisp mail archive software

On Monday, July 7, 2003, at 08:53 AM, Daniel Barlow wrote:

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


I suspected this was the case. I'm doing something similar and opted 
for a serial primary key for instances. It would be nice get an object 
ID back from the insert without the need to call currval, but I thought 
this was the best way to go since indexing is taken care of with the 
primary key specification.

Best,

John DeSoi, Ph.D.