Re: Two issues leading to discrepancies in FSM data on the standby server

From: Alexander Korotkov <aekorotkov(at)gmail(dot)com>
To: Melanie Plageman <melanieplageman(at)gmail(dot)com>
Cc: Alexey Makhmutov <a(dot)makhmutov(at)postgrespro(dot)ru>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Two issues leading to discrepancies in FSM data on the standby server
Date: 2026-05-02 16:51:52
Message-ID: CAPpHfduH+RX0=ao=KG0Tgqe89+P8AF3LCz-j9g1vuNy6sEC8kg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, May 1, 2026 at 12:57 AM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
> On Wed, Apr 22, 2026 at 10:15 AM Melanie Plageman
> <melanieplageman(at)gmail(dot)com> wrote:
> >
> > On Wed, Apr 22, 2026 at 8:32 AM Alexander Korotkov <aekorotkov(at)gmail(dot)com> wrote:
> >
> > > > It is a bug that is causing overly optimistic FSM
> > > > numbers, but it's not a correctness issue like wrong results/data
> > > > corruption etc. So, I think you could make an argument either way
> > > > about fixing it.
> > >
> > > It has user-visible effect of increased insertion time after replica
> > > promotion. I think this is quite a reason to backpatch.
> >
> > Right, since it's not invasive, I'm fine with backpatching.
>
> Alexander, are you planning on committing this?

Melanie, thank you for reminder. Yes, I'm planning to commit (with
backpatching) this in a couple of days.

------
Regards,
Alexander Korotkov
Supabase

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Nestorov 2026-05-02 17:26:43 [PATCH] btree_gist: add cross-type integer operator support for GiST
Previous Message Alexander Korotkov 2026-05-02 16:34:00 Re: Fix bug with accessing to temporary tables of other sessions