Re: go for a script! / ex: PostgreSQL vs. MySQL - Mailing list pgsql-performance

From Ron Johnson
Subject Re: go for a script! / ex: PostgreSQL vs. MySQL
Date
Msg-id 1065869007.24193.45.camel@haggis
Whole thread Raw
In response to Re: go for a script! / ex: PostgreSQL vs. MySQL  (Harald Fuchs <nospam@sap.com>)
List pgsql-performance
On Sat, 2003-10-11 at 05:22, Harald Fuchs wrote:
> In article <1065837333.12875.1.camel@jester>,
> Rod Taylor <rbt@rbt.ca> writes:
>
> >> Would anyone object to a patch that exports the blocksize via a
> >> readonly GUC?  Too many tunables are page dependant, which is
> >> infuriating when copying configs from DB to DB.  I wish pgsql had some
> >> notion of percentages for values that end with a '%'.
>
> > Rather than showing the block size, how about we change the tunables to
> > be physical sizes rather than block based?
>
> >         effective_cache_size = 1.5GB
> >         shared_buffers = 25MB
>
> Amen!  Being forced to set config values in some obscure units rather
> than bytes is an ugly braindamage which should be easy to fix.

But it's too user-friendly to do it this way!

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

When Swedes start committing terrorism, I'll become suspicious of
Scandanavians.


pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [SQL] sql performance and cache
Next
From: "Chris Faulkner"
Date:
Subject: Re: [SQL] sql performance and cache