On Thu, Dec 10, 2015 at 9:20 AM, Joshua D. Drake <j...@commandprompt.com> wrote:
> On 12/10/2015 01:12 AM, Tory M Blue wrote: > > checkpoint_timeout = 5min >> >> checkpoint_completion_target = 0.9 >> >> > The above is your problem. Make checkpoint_timeout = 1h . Also, > considering turning synchronous_commit off. > > JD > Thiis valid regardless of the workload? Seems that I would be storing a ton of data and writing it once an hour, so would have potential perf hits on the hour. I guess I'm not too up to date on the checkpoint configuration. My settings on this particular DB fsync = off #synchronous_commit = on Thanks Tory
