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

From Joshua D. Drake
Subject Re: checkpoints, proper config
Date
Msg-id 5669B47B.9010504@commandprompt.com
Whole thread Raw
In response to checkpoints, proper config  (Tory M Blue <tmblue@gmail.com>)
Responses Re: checkpoints, proper config  (Tory M Blue <tmblue@gmail.com>)
Re: checkpoints, proper config  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-performance
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



--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.


pgsql-performance by date:

Previous
From: Tory M Blue
Date:
Subject: checkpoints, proper config
Next
From: Tory M Blue
Date:
Subject: Re: checkpoints, proper config