Re: [PERFORM] checkpoint_completion_target and Ext3
Josh Berkus wrote: Given your analysis of fsync'ing behavior on Ext3, would you say that it is better to set checkpoint_completion_target to 0.0 on Ext3? Setting that to 0.0 gives the same basic behavior as in 8.2 and earlier versions. Those had even worst I/O spikes issues. Even on
[PERFORM] checkpoint_completion_target and Ext3
Greg (Smith), Given your analysis of fsync'ing behavior on Ext3, would you say that it is better to set checkpoint_completion_target to 0.0 on Ext3? -- -- Josh Berkus PostgreSQL Experts Inc.