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

Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: markw(at)osdl(dot)org, pgsql-hackers(at)postgresql(dot)org
Cc: osdldbt-general(at)lists(dot)sourceforge(dot)net
Subject: Re: OSDL DBT-2 w/ PostgreSQL 7.3.4 and 7.4beta5
Date: 2003-11-02 00:54:39
Message-ID: 200311011954.39119.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On Friday 31 October 2003 19:18, markw(at)osdl(dot)org wrote:
> These are the only database parameters I've explicitly set for each one,
> any other differences will be differences in default values:
> 	- shared_buffers = 40000
> 	- tcpip_socket = true
> 	- checkpoint_segments = 200
> 	- checkpoint_timeout = 1800

ISTM that these two are fairly unrepresentative of any real world setups.  I 
might be better to knock them way back towards there defaults and turn on 
"checkpoint_warning" to see if they should be altered. 

> 	- stats_start_collector = true
> 	- stats_command_string = true
> 	- stats_block_level = true
> 	- stats_row_level = true
> 	- stats_reset_on_server_start = true
>
> If anyone has any tuning recommendations for either 7.3 or 7.4, I'll be
> happy to try them.  Or if anyone wants to be able to poke around on the
> system, we can arrange that too.  Feel free to ask any questions.

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to

pgsql-hackers by date

Next:From: Michael MaugerDate: 2003-11-02 01:36:56
Subject: Re: Proposal: psql force prompting on notty
Previous:From: Bruce MomjianDate: 2003-11-01 22:48:25
Subject: Prepare for CVS branch

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