| From: | "Jeremy Haile" <jhaile(at)fastmail(dot)fm> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Config parameters |
| Date: | 2007-01-02 16:22:13 |
| Message-ID: | 1167754933.1316.282766279@webmail.messagingengine.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
I'm curious what parameters you guys typically *always* adjust on new
PostgreSQL installs.
I am working with a database that contains several large tables (10-20
million) and many smaller tables (hundreds of rows). My system has 2 GB
of RAM currently, although I will be upping it to 4GB soon.
My motivation in asking this question is to make sure I'm not making a
big configuration no-no by missing a parameter, and also for my own
checklist of parameters I should almost always set when configuring a
new install.
The parameters that I almost always change when installing a new system
is shared_buffers, max_fsm_pages, checkpoint_segments, and
effective_cache_size.
Are there any parameters missing that always should be changed when
deploying to a decent server?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-01-02 16:34:19 | Re: Config parameters |
| Previous Message | Tom Lane | 2007-01-02 15:07:24 | Re: Worse perfomance on 8.2.0 than on 7.4.14 |