RE: New statistics for tuning WAL buffer size - Mailing list pgsql-hackers

From Masahiro Ikeda
Subject RE: New statistics for tuning WAL buffer size
Date
Msg-id 87a3b2085a905a5f193cca9d0e694e7d@oss.nttdata.com
Whole thread Raw
In response to RE: New statistics for tuning WAL buffer size  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
Responses Re: New statistics for tuning WAL buffer size  (Fujii Masao <masao.fujii@oss.nttdata.com>)
List pgsql-hackers
On 2020-08-19 13:49, tsunakawa.takay@fujitsu.com wrote:
> From: Masahiro Ikeda <ikedamsh@oss.nttdata.com>
>> If my understanding is correct, we have to measure the performance
>> impact first.
>> Do you know HariBabu is now trying to solve it? If not, I will try to
>> modify patches to apply HEAD.
> 
> No, he's not doing it anymore.  It'd be great if you could resume it.

OK, thanks.

> However, I recommend sharing your understanding about what were the
> issues with those two threads and how you're trying to solve them.
> Was the performance overhead the blocker in both of the threads?

In my understanding, some comments are not solved in both of the 
threads.
I think the following works are remained.

1) Modify patches to apply HEAD
2) Get consensus what metrics we collect and how to use them for tuning.
3) Measure performance impact and if it leads poor performance, we solve 
it.

Regards,
-- 
Masahiro Ikeda
NTT DATA CORPORATION



pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: Creating foreign key on partitioned table is too slow
Next
From: "Drouvot, Bertrand"
Date:
Subject: Re: Display individual query in pg_stat_activity