Re: track_planning causing performance regression - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: track_planning causing performance regression
Date
Msg-id bc8125cb-264e-5a48-7d1f-17b84df831ed@oss.nttdata.com
Whole thread Raw
In response to Re: track_planning causing performance regression  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: track_planning causing performance regression
Re: track_planning causing performance regression
List 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 by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: Add Information during standby recovery conflicts
Next
From: "Jonah H. Harris"
Date:
Subject: Re: Persist MVCC forever - retain history