| 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: | Whole Thread | Raw Message | 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.
| 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 |
| 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 |