RE: New statistics for tuning WAL buffer size

Поиск
Список
Период
Сортировка
От Masahiro Ikeda
Тема RE: New statistics for tuning WAL buffer size
Дата
Msg-id 87a3b2085a905a5f193cca9d0e694e7d@oss.nttdata.com
обсуждение исходный текст
Ответ на RE: New statistics for tuning WAL buffer size  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
Ответы Re: New statistics for tuning WAL buffer size  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список 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 по дате отправления:

Предыдущее
От: Amit Langote
Дата:
Сообщение: Re: Creating foreign key on partitioned table is too slow
Следующее
От: "Drouvot, Bertrand"
Дата:
Сообщение: Re: Display individual query in pg_stat_activity