Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> Pavel Veretennikov wrote:
> | What could be a problem? About 3G of shared memory is allocated to PG,
> | 850000 shared_buffers.
> I don't know what you problem can be but are you sure you need that
> *very huge* ammount of shared memory ?
Conventional wisdom is that setting shared_buffers higher than a few
tens of thousands is a bad idea, no matter how much RAM you have.
See the pgsql-performance archives.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Nigel Bishop||Date: 2004-07-26 09:02:32|
|Subject: FW: Error in logfile on DB startup|
|Previous:||From: Steve||Date: 2004-07-26 01:46:22|
|Subject: Re: Utilizing multiple disks|