Re: subtransaction performance regression [kind of] due to snapshot caching - Mailing list pgsql-hackers

From Andres Freund
Subject Re: subtransaction performance regression [kind of] due to snapshot caching
Date
Msg-id 20210406162819.dw2u2ukx6lfm4mwl@alap3.anarazel.de
Whole thread Raw
In response to subtransaction performance regression [kind of] due to snapshot caching  (Andres Freund <andres@anarazel.de>)
List 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



pgsql-hackers by date:

Previous
From: James Coleman
Date:
Subject: Re: [EXTERNAL] Any objection to documenting pg_sequence_last_value()?
Next
From: Kazutaka Onishi
Date:
Subject: Re: TRUNCATE on foreign table