Re: Preventing free space from being reused - Mailing list pgsql-general

From Michael Lewis
Subject Re: Preventing free space from being reused
Date
Msg-id CAHOFxGq+jDKCZHJOnDpaTOUAti15Ue5TGj6mA=d1MDGpDR6TDQ@mail.gmail.com
Whole thread Raw
In response to Re: Preventing free space from being reused  (Noah Bergbauer <noah@statshelix.com>)
Responses Re: Preventing free space from being reused
List pgsql-general
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?

pgsql-general by date:

Previous
From: Noah Bergbauer
Date:
Subject: Re: Preventing free space from being reused
Next
From: Noah Bergbauer
Date:
Subject: Re: Preventing free space from being reused