Hi Andres, On Sun, Oct 22, 2023 at 12:08 PM Andres Freund <and...@anarazel.de> wrote:
> Hi, > > On October 22, 2023 4:56:15 AM PDT, Vik Fearing <v...@postgresfriends.org> > wrote: > >On 10/22/23 09:50, sirisha chamarthi wrote: > >> Is there any specific reason hot_standby_feedback default is set to off? > > > > > >Yes. No one wants a rogue standby to ruin production. > > Medium term, I think we need an approximate xid->"time of assignment" > mapping that's continually maintained on the primary. One of the things > that'd show us to do is introduce a GUC to control the maximum effect of > hs_feedback on the primary, in a useful unit. Numbers of xids are not a > useful unit (100k xids is forever on some systems, a few minutes at best on > others, the rate is not necessarily that steady when plpgsql exception > handles are used, ...) > +1 on this idea. Please let me give this a try. Thanks, Sirisha
