[postgis-users] Postgis too slow

[Dave Blasby]

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