If you have no updates or deletes, then I would wonder about setting fillfactor LOWER such that new rows are less likely to find a gap that is acceptable. Depending how/when you use the json, lowering toast_tuple_target may be appropriate to store (nearly?) all out of line and making the data stored in the main relation be more uniform in size. Are you seeing significant toast usage currently?
- Preventing free space from being reused Noah Bergbauer
- Re: Preventing free space from being reused Michael Lewis
- Re: Preventing free space from being reused Noah Bergbauer
- Re: Preventing free space from being reused Michael Lewis
- Re: Preventing free space from being reuse... Noah Bergbauer
- Re: Preventing free space from being ... Noah Bergbauer