Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id DA41764FD14 for ; Mon, 22 Dec 2008 06:35:43 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 84925-06 for ; Mon, 22 Dec 2008 06:35:41 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.28]) by mail.postgresql.org (Postfix) with ESMTP id 87C8564FD06 for ; Mon, 22 Dec 2008 06:35:40 -0400 (AST) Received: by yx-out-2324.google.com with SMTP id 8so675104yxb.73 for ; Mon, 22 Dec 2008 02:35:40 -0800 (PST) Received: by 10.64.142.8 with SMTP id p8mr4970348qbd.64.1229942139690; Mon, 22 Dec 2008 02:35:39 -0800 (PST) Received: from oxford.xeocode.com.enterprisedb.com (69-196-135-189.dsl.teksavvy.com [69.196.135.189]) by mx.google.com with ESMTPS id p9sm10426184qbp.35.2008.12.22.02.35.37 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 22 Dec 2008 02:35:38 -0800 (PST) To: "Mark Wong" Cc: "pgsql-performance\@postgresql.org" , "Selena Deckelmann" , "Gabrielle Roth" Subject: Re: dbt-2 tuning results with postgresql-8.3.5 In-Reply-To: <70c01d1d0812220050kb1f755etea3ecada3f3b8631@mail.gmail.com> (Mark Wong's message of "Mon\, 22 Dec 2008 00\:50\:20 -0800") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+imap.gmail.com:PG" 101805) References: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com> <87hc4yuxbl.fsf@oxford.xeocode.com> <552F108E-9732-4ED6-B45D-6C651C63565E@gmail.com> <87d4fkvgtj.fsf@oxford.xeocode.com> <70c01d1d0812220050kb1f755etea3ecada3f3b8631@mail.gmail.com> From: Gregory Stark Organization: EnterpriseDB Date: Mon, 22 Dec 2008 10:35:35 +0000 Message-ID: <878wq8v6o8.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/183 X-Sequence-Number: 32219 "Mark Wong" writes: >> I'm not sure how bad that is for the benchmarks. The only effect that comes to >> mind is that it might exaggerate the effects of some i/o intensive operations >> that under normal conditions might not cause any noticeable impact like wal >> log file switches or even checkpoints. > > I'm not sure I'm following. All I'm saying is that the performance characteristics won't be the same when the service wait times are 1-10 seconds rather than the 20-30ms at which alarm bells would start to ring on a real production system. I'm not exactly sure what changes it might make though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!