[postgis-users] Postgis too slow

Paul Ramsey pramsey at refractions.net
Wed May 15 12:56:03 PDT 2002


Not a dumb question. In the case of mapserver drawing, it helps not at
all. In the case of mapserver querying, it helps immensely.

Andy Turk wrote:
> 
> > Dont forget to put an index on the OID of the table you're using.
> >
> >       create index oid_geo_idx on <table> (OID);
> 
> Maybe this is a dumb question, but how does an OID index help here?
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_




More information about the postgis-users mailing list