Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




> On Aug 9, 2022, at 7:45 AM, Taylor Smith <taylorjrsmith@xxxxxxxxx> 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?







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux