[postgis-users] Postgis too slow
Paul Ramsey
pramsey@refractions.net
Wed May 15 20:56:03 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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey@refractions.net
| Phone: (250) 885-0632
\_