[postgis-users] Basic duplicating database question

[Mike Toews]

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