Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 468DA1336971 for ; Mon, 13 Dec 2010 23:31:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 58181-07 for ; Tue, 14 Dec 2010 03:31:33 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gy0-f174.google.com (mail-gy0-f174.google.com [209.85.160.174]) by mail.postgresql.org (Postfix) with ESMTP id 32B5113364DE for ; Mon, 13 Dec 2010 23:31:33 -0400 (AST) Received: by gyb11 with SMTP id 11so92717gyb.19 for ; Mon, 13 Dec 2010 19:31:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:from:to:cc:references :in-reply-to:subject:date:message-id:mime-version:content-type :content-transfer-encoding:x-mailer:thread-index:content-language; bh=YLTC77ywloDcV/JAC5ZwZDlbhlU1JgMicmnSeb7sFfE=; b=C2Bas1CbsiSDKP88Ev5lyVIARUNooQZ2NO3IBqxweomZhRozeRC/oZVoXbAdttQQye pqIsATncX573814Qm4ZrBzuLquxpHpq6ct2DU9yKV1eOlfRUtqQPZ4ipumrRwVhlArws lWCWX0q+oDo4JyEjcJusmdOCGcbhFule+bXXA= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=from:to:cc:references:in-reply-to:subject:date:message-id :mime-version:content-type:content-transfer-encoding:x-mailer :thread-index:content-language; b=T2CzLK/gp5+ZGU90siBz46FdT6s4xqGyZHD0UY1U6oq0cc0MrYbFyU/1BgUwt8uNM5 r/ESy6rP9Tg2t9r/nrHEoX3OaYqCdD7HnNkjDJ6abnbmR2dRQnAXXL/Q/OTqz4iS4Hne 0Zd7q9dTiFPbApp5A4zHdiVrKXsMgvZAJRlZw= Received: by 10.150.52.11 with SMTP id z11mr7327633ybz.36.1292297493905; Mon, 13 Dec 2010 19:31:33 -0800 (PST) Received: from Duality (67-40-151-156.hlrn.qwest.net [67.40.151.156]) by mx.google.com with ESMTPS id k2sm1236629ybj.10.2010.12.13.19.31.31 (version=SSLv3 cipher=RC4-MD5); Mon, 13 Dec 2010 19:31:32 -0800 (PST) From: "mark" To: "'Benjamin Krajmalnik'" , "'Greg Smith'" Cc: References: <4D0341D4.9000207@2ndquadrant.com> In-Reply-To: Subject: Re: Hardware recommendations Date: Mon, 13 Dec 2010 20:29:16 -0700 Message-ID: <00b701cb9b3f$17c8ed80$475ac880$@com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: AcuZFFmh0d001yr+Qs+FGerI9F836gB7VPHgAA9CUoA= Content-Language: en-us X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_LOW=-0.7 X-Spam-Level: X-Archive-Number: 201012/165 X-Sequence-Number: 41617 > -----Original Message----- > From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance- > owner@postgresql.org] On Behalf Of Benjamin Krajmalnik > Sent: Monday, December 13, 2010 1:45 PM > To: Greg Smith > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] Hardware recommendations > > > > > -----Original Message----- > > From: Greg Smith [mailto:greg@2ndquadrant.com] > > Sent: Saturday, December 11, 2010 2:18 AM > > To: Benjamin Krajmalnik > > Cc: pgsql-performance@postgresql.org > > Subject: Re: [PERFORM] Hardware recommendations > > > > Have you increased checkpoint parameters like checkpoint_segments? > You > > need to avoid having checkpoints too often if you're going to try and > > use 4GB of memory for shared_buffers. > > > > Yes, I have it configured at 1024 checkpoint_segments, 5min timeout,0.9 > compiostat -x 5letion_target I would consider bumping that checkpoint timeout duration to a bit longer and see if that helps any if you are still looking for knobs to fiddle with. YMMV. -Mark