[postgis-users] index update

Obe, Regina DND\MIS robe.dnd at ci.boston.ma.us
Fri Jun 20 06:17:11 PDT 2003

I don't think you need to drop and rebuild the index.  The new entries will
be indexed.

It's a good idea to vacuum analyze the database every so often anyway to
purge old junk and rebuild statistics.  

If you are loading a lot of data though - you may want to drop the index,
load the data and then readd the index.  I think that runs a lot faster (but
I could be wrong).

-----Original Message-----
From: Heiko.Kehlenbrink at vermes.fh-oldenburg.de
[mailto:Heiko.Kehlenbrink at vermes.fh-oldenburg.de]
Sent: Friday, June 20, 2003 3:02 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] index update

hi all, 
just a question, say i`ve got a table with a the_geom row and builded an
index on it correctly, 
after that i add some new data to that table, do i have to drop the index
and build a new one or 
will the new entries be indexed automatically or do i have to vacuum analyse
the database? 
best regards 
heiko kehlenbrink 

postgis-users mailing list
postgis-users at postgis.refractions.net

More information about the postgis-users mailing list