Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1a74ve-0004TQ-8C for pgsql-performance@arkaria.postgresql.org; Thu, 10 Dec 2015 17:22:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1a74vd-0003do-RF for pgsql-performance@arkaria.postgresql.org; Thu, 10 Dec 2015 17:22:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1a74tz-0000tK-HD for pgsql-performance@postgresql.org; Thu, 10 Dec 2015 17:21:11 +0000 Received: from www.commandprompt.com ([2604:da00:2:2:5054:ff:fe07:7618] helo=lists.commandprompt.com) by magus.postgresql.org with esmtp (Exim 4.84) (envelope-from ) id 1a74tv-0005Qm-4p for pgsql-performance@postgresql.org; Thu, 10 Dec 2015 17:21:11 +0000 Received: from [192.168.1.2] (spinlock.commandprompt.com [69.168.55.30]) by lists.commandprompt.com (Postfix) with ESMTPA id 1C86D1D5; Thu, 10 Dec 2015 09:21:03 -0800 (PST) Received: from c-67-168-169-165.hsd1.wa.comcast.net ([67.168.169.165] helo=[192.168.1.2]) by assp.commandprompt.com with SMTPSA(TLSv1_2 ECDHE-RSA-AES128-GCM-SHA256) (2.4.5); 10 Dec 2015 09:21:02 -0800 Subject: Re: checkpoints, proper config To: Tory M Blue , "pgsql-performance@postgresql.org" References: From: "Joshua D. Drake" Organization: Command Prompt, Inc. Message-ID: <5669B47B.9010504@commandprompt.com> Date: Thu, 10 Dec 2015 09:20:59 -0800 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit X-Assp-Version: 2.4.5(15162) on assp.commandprompt.com X-Assp-ID: assp.commandprompt.com m1-68063-02609 X-Assp-Session: 7FDEB5FF0EA0 (mail 1) X-Assp-Envelope-From: jd@commandprompt.com X-Assp-Intended-For: pgsql-performance@postgresql.org X-Assp-Intended-For: tmblue@gmail.com X-Assp-Original-Subject: Re: [PERFORM] checkpoints, proper config X-Assp-Client-SSL: yes X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance