[postgis-users] shp2pgsql creates spatial index *before* itinserts data? Is that right?
woodbri at swoodbridge.com
Wed Mar 8 18:24:25 PST 2006
Markus Schaber wrote:
> Hi, Ethan,
> Ethan Alpert wrote:
>>Shouldn't a VACUUM ANALYZE <table_name> also occur ?
> ANALYZE does make sense in some cases, when the statistical distribution
> of values changes. VACUUM does not make sense on a freshly created and
> populated table, only UPDATES and DELETEs cause VACUUMs to be needed.
> CLUSTER and some ALTER TABLE commands also rewrite the table, making
> VACUUM obsolete.
> Btw, most recent PostgreSQL installations have Autovacuum running, so
> the table will be vacuumed and analzyed as needed.
I think another important point to remember here is the in many cases,
for me at least, I end up loading multiple shapefiles into the same
table and I don't want to slow that down with useless analyzing when am
going to load more data.
More information about the postgis-users