Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 3B43BB5DBFD for ; Tue, 4 Oct 2011 08:09:10 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 96246-07 for ; Tue, 4 Oct 2011 11:09:03 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from exprod7og126.obsmtp.com (exprod7og126.obsmtp.com [64.18.2.206]) by mail.postgresql.org (Postfix) with ESMTP id F0EFEB5DBFC for ; Tue, 4 Oct 2011 08:09:02 -0300 (ADT) Received: from mail-ey0-f181.google.com ([209.85.215.181]) (using TLSv1) by exprod7ob126.postini.com ([64.18.6.12]) with SMTP; Tue, 04 Oct 2011 04:09:03 PDT Received: by mail-ey0-f181.google.com with SMTP id 5so443137eyg.26 for ; Tue, 04 Oct 2011 04:09:02 -0700 (PDT) Received: by 10.223.35.193 with SMTP id q1mr1525422fad.141.1317726540309; Tue, 04 Oct 2011 04:09:00 -0700 (PDT) Received: from [192.168.1.183] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi. [88.195.122.240]) by mx.google.com with ESMTPS id w6sm25108909fah.0.2011.10.04.04.08.58 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 04 Oct 2011 04:08:59 -0700 (PDT) Message-ID: <4E8AE949.8030300@enterprisedb.com> Date: Tue, 04 Oct 2011 14:08:57 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.2.21) Gecko/20110831 Icedove/3.1.13 MIME-Version: 1.0 To: Venkat Balaji CC: PGSQL Performance Subject: Re: : PG9.0 - Checkpoint tuning and pg_stat_bgwriter References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201110/36 X-Sequence-Number: 45258 On 04.10.2011 13:50, Venkat Balaji wrote: > I have got a situation where in i see the production system is loaded with > the checkpoints and at-least 1000+ buffers are being written for every > checkpoint. 1000 buffers isn't very much, that's only 8 MB, so that's not alarming itself. > I am thinking of increasing the checkpoint_segments. > > Below are our current settings - > > checkpoint_segments = 8 > checkpoint_timeout = 5 mins > checkpoint_completion_target = 0.5 > bgwriter_delay = 200ms > bgwriter_lru_maxpages = 100 > bgwriter_lru_multiplier = 2 > > Looking forward for suggestions. Yep, increase checkpoint_segments. And you probably want to raise checkpoint_timeout too. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com