Opened 19 years ago
Last modified 16 years ago
#959 closed enhancement
Add lco to PostgreSQL driver to have indexes created — at Initial Version
Reported by: | Owned by: | warmerdam | |
---|---|---|---|
Priority: | low | Milestone: | 1.6.0 |
Component: | OGR_SF | Version: | unspecified |
Severity: | minor | Keywords: | PostgreSQL GiST "spatial index" |
Cc: | Markus Neteler, Mateusz Łoskot |
Description
It would be nice if there would be a layer create option on the PostgreSQL driver to have indexes created automatically. I would suggest the following indexes: CREATE INDEX [tablename]_geom_idx ON [schema].[tablename] USING gist (wkb_geometry); CREATE INDEX [tablename]_oid_idx ON [schema].[tablename] USING btree (oid); CREATE INDEX [tablename]_ogc_fid_idx ON [schema].[tablename] USING btree (ogc_fid); And after this do a VACUUM ANALYZE;
Note:
See TracTickets
for help on using tickets.