Re: Statistics updates is delayed when using `commit and chain`

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Laetitia Avrot <laetitia(dot)avrot(at)gmail(dot)com>, Peter Eisentraut <peter(at)eisentraut(dot)org>, Japin Li <japinli(at)hotmail(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, John Naylor <john(dot)naylor(at)enterprisedb(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Statistics updates is delayed when using `commit and chain`
Date: 2022-08-01 16:40:04
Message-ID: 20220801164004.kybukw4j3svgcv54@awork3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On 2022-08-01 12:25:58 -0400, Tom Lane wrote:
> Andres Freund <andres(at)anarazel(dot)de> writes:
> > I don't like copying the same comment etc into multiple places. Given the
> > number of identical blocks for if (s->chain) blocks, perhaps we should just
> > move it into a new helper?
>
> What I suggested a few days ago is that it should be in CommitTransaction.

I wonder how we'd best deal with the idle timer if we go for that. That only
makes sense in some contexts (normal backends), but not others (everything
else).

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-08-01 16:43:23 Re: Statistics updates is delayed when using `commit and chain`
Previous Message Tom Lane 2022-08-01 16:25:58 Re: Statistics updates is delayed when using `commit and chain`