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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
