Re: Creating A GIN index on JSONB column (large database)

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Taylor Smith <taylorjrsmith(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Creating A GIN index on JSONB column (large database)
Date: 2022-08-09 14:50:46
Message-ID: 46275978-098E-42D4-BA61-AD1F7F282678@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Aug 9, 2022, at 7:45 AM, Taylor Smith <taylorjrsmith(at)gmail(dot)com> wrote:
>
> Thanks Rob,
>
> This is what I was thinking. Would you say it presents any risk then having a database unable to rebuild its own indexes if needed?
>
>

No I would not. The scale-up + rebuild should tell you how much you actually need and if you’ve over done the scale up you can scale down to what you need. Was the original spec expecting 20+T? Any chance of rolling older months off to some other node?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Taylor Smith 2022-08-09 15:29:28 Re: Creating A GIN index on JSONB column (large database)
Previous Message Taylor Smith 2022-08-09 14:45:56 Re: Creating A GIN index on JSONB column (large database)