Gaetano Mendola <mendola@bigfoot.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