Thanks a lot Michael . Concurrent index building solves my problem of building index without locking.
Best Regards, Saurav On Thu, Aug 13, 2020 at 10:45 PM Michael Lewis <mle...@entrata.com> wrote: > create index concurrently lower( jsonb->>'name' ), drop old_index > concurrently, ensure that where/on/group by conditions use lower( > jsonb->>'name' ), then take lunch. > > What's your concern with this process? > >>
