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