[postgis-users] shp2pgsql creates spatial index *before* it inserts data? Is that right?
schabi at logix-tt.com
Wed Mar 8 01:41:51 PST 2006
Ethan Alpert wrote:
> Having just upgraded from a very old version I was playing with some of
> the new (for me at least) options to shp2pgsql.
> One thing that struck me as odd is that shp2pgsql when called with –I
> creates the index before it inserts data. Shouldn’t the index be created
> Just curious. I’m using postgresql 8.1.3 and postgis 1.1.1
Functionally, it is equivialent, but perfomance wise, it is much better
to create the index afterwards.
Patches are welcome.
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf. | Software Development GIS
Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org
More information about the postgis-users