From: Nick Barr <nicky@chuckie.co.uk>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Date: Fri, 10 Oct 2003 19:08:59 +0100
Message-ID: <3F86F5BB.90605@chuckie.co.uk> (raw)
In-Reply-To: <200310101034.52073.josh@agliodbs.com>
References: <007901c38f2b$0b585590$2802a8c0@webbased10>
<200310101034.52073.josh@agliodbs.com>
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
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: nicky@chuckie.co.uk, josh@agliodbs.com
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
In-Reply-To: <3F86F5BB.90605@chuckie.co.uk>
* 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