Changes between Version 3 and Version 4 of Ticket #959


Ignore:
Timestamp:
Apr 27, 2007, 10:16:47 AM (17 years ago)
Author:
Mateusz Łoskot
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #959

    • Property Cc Mateusz Łoskot added
    • Property Keywords GiST "spatial index" added

  • Ticket #959 – Description

    v3 v4  
    1 {{{
    2 It would be nice if there would be a layer create option on the PostgreSQL
    3 driver to have indexes created automatically.
     1It would be nice if there would be a layer create option on the PostgreSQL driver to have indexes created automatically.
    42
    53I would suggest the following indexes:
    64
     5{{{
    76CREATE INDEX [tablename]_geom_idx
    87  ON [schema].[tablename]
    … …  
    1918  USING btree
    2019  (ogc_fid);
     20}}}
    2121
    2222And after this do a VACUUM ANALYZE;
    23 }}}