On Thu, Dec 10, 2015 at 9:20 AM, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx> 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
