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

2022-08-09 Thread Taylor Smith
ld help as its likely largest partition will either be the current month or the previous month so the problem would still persist. On Tue, Aug 9, 2022 at 3:50 PM Rob Sargent wrote: > > > > On Aug 9, 2022, at 7:45 AM, Taylor Smith > wrote: > > > > Thanks Rob, > >

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

2022-08-09 Thread Taylor Smith
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? On Tue, Aug 9, 2022 at 3:39 PM Rob Sargent wrote: > > > > On Aug 9, 2022, at 7:04 AM, Taylor Smith > wrote: > > > &g

Creating A GIN index on JSONB column (large database)

2022-08-09 Thread Taylor Smith
to mitigate or a necessary evil. The only solution we have so far is scale up our RDS instance. Kind regards, Taylor Smith