On 21 October 2010 04:38, lplateandy <a...@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
