Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 23CCF64FD23 for ; Mon, 22 Dec 2008 23:51:14 -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 92910-05 for ; Mon, 22 Dec 2008 23:51:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from westnet.com (westnet.com [216.187.52.2]) by mail.postgresql.org (Postfix) with ESMTP id 9F71A64FC18 for ; Mon, 22 Dec 2008 23:51:11 -0400 (AST) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id mBN3p8Js009085; Mon, 22 Dec 2008 22:51:08 -0500 (EST) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id mBN3p8mi009081; Mon, 22 Dec 2008 22:51:08 -0500 (EST) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Mon, 22 Dec 2008 22:51:08 -0500 (EST) From: Greg Smith X-X-Sender: gsmith@westnet.com 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: <70c01d1d0812221930t6a9bdd9aw8dcfe14761a340bd@mail.gmail.com> Message-ID: References: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com> <70c01d1d0812221930t6a9bdd9aw8dcfe14761a340bd@mail.gmail.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=NORMAL_HTTP_TO_IP=0.001 X-Spam-Level: X-Archive-Number: 200812/200 X-Sequence-Number: 32236 On Mon, 22 Dec 2008, Mark Wong wrote: > The shared_buffers are the default, 24MB. The database parameters are > saved, probably unclearly, here's an example link: > > http://207.173.203.223/~markwkm/community6/dbt2/baseline.1000.1/db/param.out That's a bit painful to slog through to find what was changed from the defaults. How about saving the output from this query instead, or in addition to the version sorted by name: select name,setting,source,short_desc from pg_settings order by source,name; Makes it easier to ignore everything that isn't set. > I should probably run your pgtune script, huh? That's basically where the suggestions for center points I made came from. The only other thing that does that might be interesting to examine is that it bumps up checkpoint_completion_target to 0.9 once you've got a large number of checkpoint_segments. -- * Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD