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: | Raw Message | Whole Thread | 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 |