Re: initdb profiles

Hello All,
    Please allow me to put a disclaimer, I am no serious PG hacker, 
but would it be possible to allow for a simple config script to be run 
(which would work even via /etc/init.d) which could be used to generate a 
config file for initdb, which initdb could read and do its thing ?
    This script could say do you wish to do a manual adjustment or 
accept the default values, and then initdb could feed off that file. Does 
this create too much work or is it disadvantageous.
    Cheers,
    Aly.


On Wed, 7 Sep 2005, Andrew Dunstan wrote:

>
>
> Peter Eisentraut wrote:
>
>> Andrew Dunstan wrote:
>> 
>>> I accept the "run from init.d" argument. So then, is there a case for
>>> increasing the limits that initdb works with, to reflect the steep
>>> rise we have seen in typically available memory at the low end?
>>> 
>> 
>> There is a compromise that I think we cannot make.  For production 
>> deployment, shared buffers are typically sized at about 10% to 25% of 
>> available phyiscal memory.  I don't think we want to have a default 
>> installation of PostgreSQL that takes 10% or more of memory just like that. 
>> It just doesn't look good.
>> 
>
> I have a single instance of apache running on this machine. It's not doing 
> anything, but even so it's consuming 20% of physical memory. By contrast, my 3 
> postmasters are each consuming 0.5% of memory. All with default settings. I 
> don't think we are in any danger of looking bad for being greedy. If anything 
> we are in far greater danger of looking bad from being far too conservative 
> and paying a performance price for that. There's nothing magical about the 
> numbers we use.
>
>> So the question whether initdb should by default consider up to 1000 or up 
>> to 4000 buffers is still worth discussion, but doesn't solve the tuning 
>> issue to a reasonable degree.
>> 
>>
>> 
>
> True, but that doesn't mean it's not worth doing anyway.
>
> cheers
>
> andrew
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

-- 
Aly S.P Dharshi
aly.dharshi@telus.net
     "A good speech is like a good dress      that's short enough to be interesting      and long enough to cover the
subject"