Skip site navigation (1) Skip section navigation (2)

Re: dbt-2 tuning results with postgresql-8.3.5

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To: Mark Wong <markwkm(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>, Selena Deckelmann <selenamarie(at)gmail(dot)com>, Gabrielle Roth <gorthx(at)gmail(dot)com>
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Date: 2008-12-23 03:51:08
Message-ID: Pine.GSO.4.64.0812222236220.6114@westnet.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

pgsql-performance by date

Next:From: Alvaro HerreraDate: 2008-12-23 12:01:06
Subject: Re: dbt-2 tuning results with postgresql-8.3.5
Previous:From: Mark WongDate: 2008-12-23 03:48:57
Subject: Re: dbt-2 tuning results with postgresql-8.3.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group