Re: checkpoints, proper config

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tory M Blue <tmblue(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: checkpoints, proper config
Date: 2015-12-10 17:20:59
Message-ID: 5669B47B.9010504@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tory M Blue 2015-12-10 18:35:22 Re: checkpoints, proper config
Previous Message Tory M Blue 2015-12-10 09:12:19 checkpoints, proper config