Re: Disable WAL logging to speed up data loading

Поиск
Список
Период
Сортировка
От David Steele
Тема Re: Disable WAL logging to speed up data loading
Дата
Msg-id c3b64bb9-5108-796b-93db-96d2cee0c3a2@pgmasters.net
обсуждение исходный текст
Ответ на RE: Disable WAL logging to speed up data loading  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
Ответы RE: Disable WAL logging to speed up data loading  ("tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>)
Список pgsql-hackers
On 1/17/21 12:16 AM, tsunakawa.takay@fujitsu.com wrote:
> From: Osumi, Takamichi/大墨 昂道 <osumi.takamichi@fujitsu.com>
>> I updated my patch to take in those feedbacks !
>> Have a look at the latest patch.
> 
> Looks good to me (the status remains ready for committer.)

After reading through the thread (but not reading the patch) I am -1 on  
this proposal.

The feature seems ripe for abuse and misunderstanding, and as has been  
noted in the thread, there are a variety of alternatives that can  
provide a similar effect.

It doesn't help that at several points along the way new WAL records  
have been found that still need to be included even when wal_level =  
none. It's not clear to me how we know when we have found them all.

The patch is marked Ready for Committer but as far as I can see there  
are no committers in favor of it and quite a few who are not.

Perhaps it would be better to look at some of the more targeted  
approaches mentioned in the thread and see if any of them can be  
used/improved to achieve the desired result?

Regards,
-- 
-David
david@pgmasters.net



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

Предыдущее
От: Tomas Vondra
Дата:
Сообщение: Re: cleanup temporary files after crash
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: fdatasync performance problem with large number of DB files