| From: | Robert James <srobertjames(at)gmail(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Memory tuning Postgres |
| Date: | 2012-02-15 14:20:06 |
| Message-ID: | CAGYyBgh0wEd6WueTeFQ4Q26fWtkX9ZSsSdn8ysy7a4tWqDDDeA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2012-02-15 14:28:02 | Re: Rules of Thumb for Autovaccum |
| Previous Message | Robert James | 2012-02-15 14:16:06 | Index for low selectivity field |