Re: [GENERAL] Queries on async replicas locked each other after index rename on master

2016-08-30 Thread Venkata B Nagothi
On Wed, Aug 31, 2016 at 8:07 AM, Chinh Nguyen wrote: > Hello All, > > We recently tried to reindex on a heavy used database cluster (master > + multiple hot-standby async replicas, all taking traffic) and > replicas were effectively blocked for 10 minutes resulting in drop of > a lot of read traf

[GENERAL] Queries on async replicas locked each other after index rename on master

2016-08-30 Thread Chinh Nguyen
Hello All, We recently tried to reindex on a heavy used database cluster (master + multiple hot-standby async replicas, all taking traffic) and replicas were effectively blocked for 10 minutes resulting in drop of a lot of read traffic. We reindex by create new index concurrently, then rename old