Re: Case insensitive query on existing data

From: Saurav Sarkar <saurav(dot)sarkar1(at)gmail(dot)com>
To: Michael Lewis <mlewis(at)entrata(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Case insensitive query on existing data
Date: 2020-08-13 18:46:50
Message-ID: CAP+kwAXAEO1vzb1Wujfo5EKrvVPSfHK1JtOYw-5ET4ng3OKapQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)entrata(dot)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?
>
>>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rene Romero Benavides 2020-08-14 06:39:20 PostgreSQL 10.12. background writer not cleaning buffers, small working set, big shared_buffers
Previous Message Adrian Klaver 2020-08-13 17:31:00 Re: Fwd: changing password pgagent service account