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

Michael Fuhr mike at fuhr.org
Wed Mar 8 13:43:43 PST 2006


On Wed, Mar 08, 2006 at 10:19:41PM +0100, Markus Schaber wrote:
> Btw, most recent PostgreSQL installations have Autovacuum running, so
> the table will be vacuumed and analzyed as needed.

Only 8.1 has autovacuum integrated into the backend and it's not
enabled by default, at least not in the stock installation (third-party
packages might enable it by default).  It's a stretch to say that
most recent installations have it running when it must be manually
enabled; if you don't know if it's running then it probably isn't.

-- 
Michael Fuhr



More information about the postgis-users mailing list