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