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

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: subtransaction performance regression [kind of] due to snapshot caching
Дата
Msg-id 20210406162819.dw2u2ukx6lfm4mwl@alap3.anarazel.de
обсуждение исходный текст
Ответ на subtransaction performance regression [kind of] due to snapshot caching  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: James Coleman
Дата:
Сообщение: Re: [EXTERNAL] Any objection to documenting pg_sequence_last_value()?
Следующее
От: Kazutaka Onishi
Дата:
Сообщение: Re: TRUNCATE on foreign table