Re: Preventing free space from being reused

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Noah Bergbauer <noah(at)statshelix(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Preventing free space from being reused
Date: 2021-02-12 16:48:40
Message-ID: CAHOFxGq+jDKCZHJOnDpaTOUAti15Ue5TGj6mA=d1MDGpDR6TDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Noah Bergbauer 2021-02-12 17:38:06 Re: Preventing free space from being reused
Previous Message Noah Bergbauer 2021-02-12 16:36:09 Re: Preventing free space from being reused