Postgres Pro
Downloads
Home   >   mailing lists

Re: checkpoints, proper config - Mailing list pgsql-performance

From Tory M Blue
Subject Re: checkpoints, proper config
Date
Msg-id CAEaSS0YJQ68TNffwjU71KxR-JsWfHSitWYgwcw4X=d4WW7zavQ@mail.gmail.com
Whole thread Raw
In response to Re: checkpoints, proper config  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: checkpoints, proper config  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
Tree view


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

pgsql-performance by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: checkpoints, proper config
Next
From: "Joshua D. Drake"
Date:
Subject: Re: checkpoints, proper config