Postgres Pro
Downloads
Home   >   mailing lists

Re: Case insensitive query on existing data - Mailing list pgsql-general

From Saurav Sarkar
Subject Re: Case insensitive query on existing data
Date
Msg-id CAP+kwAXAEO1vzb1Wujfo5EKrvVPSfHK1JtOYw-5ET4ng3OKapQ@mail.gmail.com
Whole thread Raw
In response to Re: Case insensitive query on existing data  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Tree view
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 <mlewis@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?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Fwd: changing password pgagent service account
Next
From: Rene Romero Benavides
Date:
Subject: PostgreSQL 10.12. background writer not cleaning buffers, small working set, big shared_buffers