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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
