[postgis-users] Postgis too slow

Dave Blasby dblasby at refractions.net
Wed May 15 09:51:12 PDT 2002


Paul Ramsey wrote:
> 
> Check some queries, do some bounding box queries using 'explain' and see
> if you are getting index scans. Remember to 'vacuum analyze' your
> database after building the indexes. Be peaceful and good.

Dont forget to put an index on the OID of the table you're using.

	create index oid_geo_idx on <table> (OID);

dave




More information about the postgis-users mailing list