Re: postgresql.conf.* - Mailing list pgsql-advocacy

From Marc G. Fournier
Subject Re: postgresql.conf.*
Date
Msg-id 20060104160940.R1088@ganymede.hub.org
Whole thread Raw
In response to Re: postgresql.conf.*  (Josh Berkus <josh@agliodbs.com>)
List pgsql-advocacy
On Wed, 4 Jan 2006, Josh Berkus wrote:

> Paul,
>
>> Is there any reason we cannot ship with 3 .conf files?  For each one,
>> note the minimum system configuration required to support it.
>>
>> postgresql.conf.standard  (current)
>> postgresql.conf.medium  (1Gb of RAM, IDE RAID 1 (7200RPM))
>> postgresql.conf.performance (4Gb of RAM, SCSI RAID 10 (10000RPM))
>
> Because too many of the conf parameters are dependant on *exactly* the
> amount of RAM that you have.

When we initdb, we try and come up with a suitable # for shared_buffers
... is there anything we can do to install "recommended values" for some
of the other values that are memory dependent?  At least put them into the
ball park?

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664

pgsql-advocacy by date:

Previous
From: Josh Berkus
Date:
Subject: Re: postgresql.conf.*
Next
From: "Jim C. Nasby"
Date:
Subject: Re: postgresql.conf.*