Message-ID: <3F86F5BB.90605@chuckie.co.uk>
Date: Fri, 10 Oct 2003 19:08:59 +0100
From: Nick Barr <nicky@chuckie.co.uk>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.5b) Gecko/20030901 Thunderbird/0.2
MIME-Version: 1.0
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: go for a script! / ex:  PostgreSQL vs. MySQL
References: <007901c38f2b$0b585590$2802a8c0@webbased10>
	<200310101034.52073.josh@agliodbs.com>
In-Reply-To: <200310101034.52073.josh@agliodbs.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Josh Berkus wrote:

>Nick,
>
>  
>
>>Having been following the thread on "go for a script! / ex: PostgreSQL vs.
>>MySQL". I thought I would throw something together in Perl. 
>>    
>>
>
>Cool!   Would you be willing to work with me so that I can inject some of my 
>knowledge of .conf tuning?
>
>  
>
Sounds good to me. I will carry on working on it but I would definitely 
need some help, or at least a list of parameters to tweak, and some 
recomended values based on data about the puter in question.

So far:

shared_buffers = 1/16th of total memory
effective_cache_size = 80% of the supposed kernel cache.

I guess we also may be able to offer a simple and advanced mode. Simple 
mode would work on these recomended values, but kick it into advanced 
mode and the user can tweak things more finely. This would only be 
recomended for the Guru's out there of course. This may take a bit more 
time to do though.

As I said in the previous email I have only got access to Linux, so 
cross-platform help would be good too. I will try to make it as easy to 
do cross platform stuff as possible of course.


Nick