Gaetano Mendola <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
