Re: go for a script! / ex: PostgreSQL vs. MySQL

From: Harald Fuchs <nospam(at)sap(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: go for a script! / ex: PostgreSQL vs. MySQL
Date: 2003-10-11 10:22:42
Message-ID: pupth43wgd.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

In article <1065837333(dot)12875(dot)1(dot)camel(at)jester>,
Rod Taylor <rbt(at)rbt(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2003-10-11 10:32:07 Re: [GENERAL] Partial indices...
Previous Message Richard Huxton 2003-10-11 09:30:04 Re: "slicing" records

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2003-10-11 10:39:10 Re: [SQL] sql performance and cache
Previous Message Christopher Kings-Lynne 2003-10-11 10:16:35 Re: sql performance and cache