On Wed, 13 Mar 2024 at 14:27, Laurenz Albe <laurenz.a...@cybertec.at> wrote: > > On Thu, 2023-09-21 at 16:18 -0700, Andres Freund wrote: > > I think a minimal working approach could be to have the configuration be > > based > > on the relation size vs space known to the FSM. If the target block of an > > update is higher than ((relation_size - fsm_free_space) * > > new_reloption_or_guc), try finding the target block via the FSM, even if > > there's space on the page. > > That sounds like a good way forward. > > The patch is in state "needs review", but it got review. I'll change it to > "waiting for author".
Then I'll withdraw this patch as I don't currently have (nor expect to have anytime soon) the bandwitdh or expertise to rewrite this patch to include a system that calculates the free space available in a relation. I've added a TODO item in the UPDATE section with a backlink to this thread so the discussion isn't lost. -Matthias