On 21 October 2010 07:24, lplateandy <a...@centremaps.co.uk> wrote: > > 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?
Oh right, there is a lock on reads to the index with REINDEX, so the index is useless. I missed that detail. A table without a readable index is probably no good for your situation. Here is another helpful doc page to explain locks: http://www.postgresql.org/docs/8.4/static/explicit-locking.html Also, to change the doc version, just edit the URL to your version (e.g., replace 8.4 with 8.2 or whatever). -Mike _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
