[postgis-users] index update

[Obe, Regina DND\MIS]

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
http://postgis.refractions.net/mailman/listinfo/postgis-users