Re: Disable WAL logging to speed up data loading

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