[postgis-users] shp2pgsql creates spatial index *before* itinserts data? Is that right?

Markus Schaber schabi at logix-tt.com
Wed Mar 8 13:19:41 PST 2006

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.

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 mailing list