Re: postgresql.conf.*

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-advocacy(at)postgresql(dot)org, Paul Ramsey <pramsey(at)refractions(dot)net>
Subject: Re: postgresql.conf.*
Date: 2006-01-04 20:11:02
Message-ID: 20060104160940.R1088@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Roderick A. Anderson 2006-01-05 22:41:59 Tools ... once again
Previous Message Josh Berkus 2006-01-04 20:10:28 Re: postgresql.conf.*