From: Greg Smith <gsmith@gregsmith.com>
To: Mark Wong <markwkm@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Cc: Selena Deckelmann <selenamarie@gmail.com>
Cc: Gabrielle Roth <gorthx@gmail.com>
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Date: Mon, 22 Dec 2008 22:51:08 -0500 (EST)
Message-ID: <Pine.GSO.4.64.0812222236220.6114@westnet.com> (raw)
In-Reply-To: <70c01d1d0812221930t6a9bdd9aw8dcfe14761a340bd@mail.gmail.com>
References: <70c01d1d0812201654i5f55150ep619a6c7ff094470@mail.gmail.com>
<Pine.GSO.4.64.0812220335320.11013@westnet.com>
<70c01d1d0812221930t6a9bdd9aw8dcfe14761a340bd@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: gsmith@gregsmith.com, markwkm@gmail.com, selenamarie@gmail.com, gorthx@gmail.com
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
In-Reply-To: <Pine.GSO.4.64.0812222236220.6114@westnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox