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 15:57:38
Message-ID: CAHOFxGo6op8yKiOioWocMLiBHc6j2yzi-NwW2smWAyewwXgueQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What version are you using? What is your usage pattern for
insert/update/deletes? If sometimes the JSON data gets too big and the data
is moved from in-line storage to TOASTED, then that would be opening up
gaps. Or if you are doing deletes. Perhaps adjusting your fillfactor
and/or TOAST_TUPLE_TARGET would influence that behavior in the direction
you want to go. As best I understand though if you are doing deletes, you
won't be able to prevent those gaps from showing up and being re-used. I
don't believe there is any way to influence Postgres to append-only the
tuples and pages.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Noah Bergbauer 2021-02-12 16:36:09 Re: Preventing free space from being reused
Previous Message Tom Lane 2021-02-12 15:14:17 Re: kernel.shmmax and kernel.shmall for Linux server