pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Harald Fuchs <nospam@sap.com>
To: pgsql-performance@postgresql.org
Subject: Re: go for a script! / ex:  PostgreSQL vs. MySQL
Date: 11 Oct 2003 12:22:42 +0200
Message-ID: <pupth43wgd.fsf@srv.protecting.net> (raw)
References: <007901c38f2b$0b585590$2802a8c0@webbased10>
	<200310101034.52073.josh@agliodbs.com>
	<3F86F5BB.90605@chuckie.co.uk>
	<x7wubcon3h.fsf@yertle.int.kciLink.com>
	<20031010225924.GC8664@perrin.nxad.com>
	<1065837333.12875.1.camel@jester>

In article <camel@jester/">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.




view thread (42+ messages)  latest in thread

Message-ID: <pupth43wgd.fsf@srv.protecting.net>
Permalink:  ../pupth43wgd.fsf@srv.protecting.net/
Also on:    postgresql.org/message-id/pupth43wgd.fsf@srv.protecting.net

 · 

reply

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: nospam@sap.com
  Subject: Re: go for a script! / ex:  PostgreSQL vs. MySQL
  In-Reply-To: <pupth43wgd.fsf@srv.protecting.net>

* 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