Re: track_planning causing performance regression

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: track_planning causing performance regression
Дата
Msg-id bc8125cb-264e-5a48-7d1f-17b84df831ed@oss.nttdata.com
обсуждение исходный текст
Ответ на Re: track_planning causing performance regression  (Peter Geoghegan <pg@bowt.ie>)
Ответы Re: track_planning causing performance regression  (Peter Geoghegan <pg@bowt.ie>)
Re: track_planning causing performance regression  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers

On 2020/07/01 7:37, Peter Geoghegan wrote:
> On Tue, Jun 30, 2020 at 6:40 AM Fujii Masao <masao.fujii@oss.nttdata.com> wrote:
>> Ants and Andres suggested to replace the spinlock used in pgss_store() with
>> LWLock. I agreed with them and posted the POC patch doing that. But I think
>> the patch is an item for v14. The patch may address the reported performance
>> issue, but may cause other performance issues in other workloads. We would
>> need to measure how the patch affects the performance in various workloads.
>> It seems too late to do that at this stage of v13. Thought?
> 
> I agree that it's too late for v13.

Thanks for the comment!

So I pushed the patch and changed default of track_planning to off.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: Add Information during standby recovery conflicts
Следующее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Persist MVCC forever - retain history