Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 8B5699FBB57 for ; Mon, 9 Jul 2007 13:28:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 74537-08 for ; Mon, 9 Jul 2007 13:28:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.171]) by postgresql.org (Postfix) with ESMTP id 82CC29FBB56 for ; Mon, 9 Jul 2007 13:28:18 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so1262416ugf for ; Mon, 09 Jul 2007 09:28:17 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=cX79Q6JHonmiBLrEO7MGWb+E2HUkamJAUhdyBH8UlbJR7KpF0EiVlst4zBqJszhXdE2BVU0qcaUQ4PWeNTatCj3/tMvkYEJaiEn40V4nyA8bHLiGHlQDhy2LK34C9IfGLDxHb32c6b/DD8nk37+xhM95j5bQR0vcA6W8jDz14Wg= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=azJiJJLZgcWL8ZoFu4+TvbnLSWQg5vuVKOhhjZOazeMUDNjmaeOcPHT+qGBZfs83uUN3yAREO+PdQrDgN1L7bvJN9DE76t3WuFeR33lZmZy4idSfSFfchvX6+3af2WXyFXhmffuSQ+Zqkdwr9ciYurCDeFxvLjyTAb1wjlNM/WI= Received: by 10.67.95.3 with SMTP id x3mr5206738ugl.1183998497229; Mon, 09 Jul 2007 09:28:17 -0700 (PDT) Received: from ?192.168.1.33? ( [82.13.24.118]) by mx.google.com with ESMTPS id e23sm2935478ugd.2007.07.09.09.28.12 (version=SSLv3 cipher=RC4-MD5); Mon, 09 Jul 2007 09:28:15 -0700 (PDT) Message-ID: <469261EC.7080106@enterprisedb.com> Date: Mon, 09 Jul 2007 17:27:24 +0100 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: "Jignesh K. Shah" CC: pgsql-performance@postgresql.org Subject: Re: PostgreSQL publishes first real benchmark References: <46925AD9.9020208@sun.com> In-Reply-To: <46925AD9.9020208@sun.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/58 X-Sequence-Number: 25742 Jignesh K. Shah wrote: > Hello all, > > I think this result will be useful for performance discussions of > postgresql against other databases. > > http://www.spec.org/jAppServer2004/results/res2007q3/ > > More on Josh Berkus's blog: > > http://blogs.ittoolbox.com/database/soup/archives/postgresql-publishes-first-real-benchmark-17470 That's really exciting news! I'm sure you spent a lot of time tweaking the settings, so let me ask you something topical: How did you end up with the bgwriter settings you used? Did you experiment with different values? How much difference did it make? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com