Re: subtransaction performance regression [kind of] due to snapshot caching

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: subtransaction performance regression [kind of] due to snapshot caching
Date: 2021-04-06 16:28:19
Message-ID: 20210406162819.dw2u2ukx6lfm4mwl@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2021-04-05 21:35:21 -0700, Andres Freund wrote:
> See the attached fix. I did include a test that verifies that the
> kill_prior_tuples optimization actually prevents the index from growing,
> when subtransactions are involved. I think it should be stable, even
> with concurrent activity. But I'd welcome a look.

Pushed that now, after trying and failing to make the test spuriously
fail due to concurrent activity.

Greetings,

Andres Freund

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2021-04-06 16:32:16 Re: shared-memory based stats collector
Previous Message James Coleman 2021-04-06 16:13:38 Re: [EXTERNAL] Any objection to documenting pg_sequence_last_value()?