I have a 4 core, 4 GB server dedicated to running Postgres (only other
thing on it are monitoring, backup, and maintenance programs). It
runs about 5 databases, backing up an app, mainly ORM queries, but
some reporting and more complicated SQL JOINs as well.
I'm currently using the out-of-the box postgresql.conf, but I get the
sense that isn't using all the resources it should.
What parameters should I change to use the server best? What are good
starting points or them? What type of performance increase should I
see?
From basic research, it seems shared_buffers should be 1G, and
effective_cache_size 3G. Is that correct? Can you suggest what other
params I should change, and to what?