Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 16A1C1337BBA for ; Wed, 2 Feb 2011 14:23:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 35843-03 for ; Wed, 2 Feb 2011 18:23:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by mail.postgresql.org (Postfix) with ESMTP id AB9C11337BEA for ; Wed, 2 Feb 2011 14:23:01 -0400 (AST) Received: from [192.168.1.6] (mail.highperformancepostgresql.com [71.179.240.8]) by mrelayeu.kundenserver.de (node=mrbap1) with ESMTP (Nemesis) id 0MFR0G-1Pyz6z25g4-00EZbn; Wed, 02 Feb 2011 19:22:57 +0100 Message-ID: <4D49A0FF.4010104@2ndquadrant.com> Date: Wed, 02 Feb 2011 13:22:55 -0500 From: Greg Smith User-Agent: Thunderbird 2.0.0.24 (X11/20100317) MIME-Version: 1.0 To: Benjamin Krajmalnik CC: pgsql-performance@postgresql.org Subject: Re: Configuration for a new server. References: <4D47F44D.2000305@2ndquadrant.com> <4D48B06A.6020100@2ndquadrant.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Provags-ID: V02:K0:bzELDNfOlXjjGHsS+lW7/w8zl/4FAUTlS1nEMxWY3UR sNfm25yXSiR7vdAZlixP1RW/e6D8L9Lm7jvSRrxBaVusTKxrUN K2HDEwob5/fTnG6p6JBxKuhqHvYS1xz6khrfEx6aCu8cjY1eF/ 5JWphdN60IjvmxV66+ZmD4LP2xP3QwcVcGOzUGbvMQ6IAdM95W OmM+93GLUzagopYGH8yAHomY8uTuzXfkz9jabPmzI0= 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, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201102/32 X-Sequence-Number: 42170 Benjamin Krajmalnik wrote: > So, if I understand correctly, I should strive for a relative increase in buffers_clean to buffers_backend > Right. Buffers written by a backend are the least efficient way to get data out of the buffer cache, because the client running into that is stuck waiting for a write call before it can use the resuling free block. You want to avoid those in favor of checkpoint and background-writer cleaner writes instead. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books