Re: GUC with units, details - Mailing list pgsql-hackers

From Tom Lane
Subject Re: GUC with units, details
Date
Msg-id 5448.1154003117@sss.pgh.pa.us
Whole thread Raw
In response to Re: GUC with units, details  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: GUC with units, details  ("Florian G. Pflug" <fgp@phlo.org>)
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> Tom Lane wrote:
>> Peter's not said exactly how he plans to deal with
>> this, but I suppose it'll round off one way or the other ...

> It'll get truncated by integer division.  I wouldn't mind if someone 
> proposed a patch to create a warning or error in this case, but I 
> wanted to keep the initial version simple.

I'd recommend against that.  Apple recently changed OS X so that
it rejects SHMMAX settings that aren't an exact multiple of
something-or-other, and I've found that to be a *serious* PITA.
Of course part of the problem is that there's no helpful message,
but it's still a big loss from a usability standpoint, and quite
unnecessary (every other Unix seems willing to round off...)

One thought is that maybe we should round up not down?  I'm having
a hard time making a specific case either way, though.
        regards, tom lane


pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: Resurrecting per-page cleaner for btree
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] extension for sql update