Re: [PERFORM] checkpoint_completion_target and Ext3

2011-02-06 Thread Greg Smith
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

2011-02-04 Thread Josh Berkus
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.