Re: checkpoints, proper config
| От | Tory M Blue |
|---|---|
| Тема | Re: checkpoints, proper config |
| Дата | |
| Msg-id | CAEaSS0YJQ68TNffwjU71KxR-JsWfHSitWYgwcw4X=d4WW7zavQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: checkpoints, proper config ("Joshua D. Drake" <jd@commandprompt.com>) |
| Ответы |
Re: checkpoints, proper config
|
| Список | pgsql-performance |
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 по дате отправления: