[postgis-users] Basic duplicating database question

[lplateandy]

Hi Mike,

OK - that's really useful. Does that only work for 9 or does it just happen
you're pointing to the 9 document?

The doc says "It also takes an exclusive lock on the specific index being
processed, which will block reads that attempt to use that index."

Does that mean that i'm not really any better off as the spatial index is
really the critical means controlling the reading of data into my GIS etc?

What would be your scenario for a full vacuum?

Thanks

Andy


Mike Toews-2 wrote:
> 
> On 21 October 2010 04:38, lplateandy <andy at centremaps.co.uk> wrote:
>> Of course, even better would be a way to reindex whilst a database is in
>> use
>> but i'm under the impression that this is not possible at the moment?
> 
> If you DROP/CREATE your index then reads are blocked. But if you use
> REINDEX then only writes are blocked, while reads are still allowed
> using the old index.
> http://www.postgresql.org/docs/9.0/static/sql-reindex.html
> 
> -Mike
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://old.nabble.com/Basic-duplicating-database-question-tp30018606p30020021.html
Sent from the PostGIS - User mailing list archive at Nabble.com.