Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating A GIN index on JSONB column (large database) - Mailing list pgsql-general

From Rob Sargent
Subject Re: Creating A GIN index on JSONB column (large database)
Date
Msg-id 46275978-098E-42D4-BA61-AD1F7F282678@gmail.com
Whole thread Raw
In response to Re: Creating A GIN index on JSONB column (large database)  (Taylor Smith <taylorjrsmith@gmail.com>)
Responses Re: Creating A GIN index on JSONB column (large database)
List pgsql-general
Tree view 

> On Aug 9, 2022, at 7:45 AM, Taylor Smith <taylorjrsmith@gmail.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
indexesif 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
youcan scale down to what you need.  Was the original spec expecting 20+T?  Any chance of rolling older months off to
someother node?

pgsql-general by date:

Previous
From: Taylor Smith
Date:
Subject: Re: Creating A GIN index on JSONB column (large database)
Next
From: Taylor Smith
Date:
Subject: Re: Creating A GIN index on JSONB column (large database)