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 wrote:
> create index concurrently lower( jsonb->>'name' ), drop old_index
> concurrently, ensure that where/on/group by cond
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?
>
Hi All,
We use PostgreSQL JSONB storage.
One of the keys in the JSON will be always have a "name" key.
We want to perform case insensitive query on the name key.
Our application is already live so we have some data and have existing
indexes on the name key.
I understand that one of the ways is
