From: Ivan Voras <ivoras@fer.hr>
To: pgsql-performance@postgresql.org
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Date: Mon, 13 Oct 2003 00:47:38 +0200
Message-ID: <00af01c39112$d9ac4350$bf8ec6c1@flatline> (raw)
References: <20031012213527.BB2B61CB4664@svr4.postgresql.org>
> Date: Sun, 12 Oct 2003 13:30:45 -0700
> From: Josh Berkus <josh@agliodbs.com>
> To: Nick Barr <nicky@chuckie.co.uk>
> Cc: pgsql-performance@postgresql.org
> Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
> Message-ID: <200310121330.45115.josh@agliodbs.com>
>
>> This would be parameters such as the block size and a few other
>> compile time parameters. If we can get to some of these read-only
>> parameters than that would make this step easier, certainly for the new
>> recruits amongst us.
>
> Actually, from my perspective, we shouldn't bother with this; if an admin
> knows enough to set an alternate blaock size for PG, then they know
> enough to tweak the Conf file by hand. I think we should just issue a
> warning that this script:
> 1) does not work for anyone who is using non-default block sizes,
There was some talk, either on this list or freebsd-performance about
setting the default block size for PostgreSQL running on FreeBSD to be 16k
because of performance reasons. That is: *default* for the port, user is not
asked. So an automagical method to scale non-default block sizes is a very
needed thing.
> 2) may not work well for anyone using unusual locales, optimization
> flags, or other non-default compile options except for language
> interfaces.
Depends on what you consider 'unusual'? I hope not things like iso8859-x
(or, to be exact, European languages) :)
--
Logic is a systematic method of coming to the wrong conclusion with
confidence.
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: ivoras@fer.hr
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
In-Reply-To: <00af01c39112$d9ac4350$bf8ec6c1@flatline>
* 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