BuyAndRead Test wrote:
>> This is a virtual server, so I could give it as much as 8 GB of memory if
>> this will give much higher performance. What should shared_buffere be
>> set to
>> if I use 8 GB, as much as 4 GB?
John R Pierce wrote:
> I'd keep it around 1-2GB shared_buffers, and let the rest of the memory
> be used as file system cache. postgres works quite happily that way.
From what I understand, database tuning is one of the Dark Arts. PG is
unique in that it's enterprise-grade but that standard settings work well
across a wide range of usage scenarios. If you are dealing with unusually
large numbers of connections and/or unusually large working sets, I'm guessing
as you approach terabyte-scale dbs and up, it pays to go to even larger
shared_buffers and work_mem and do other arcane tuning magic.
--
Lew