Config parameters

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?

Responses

Browse pgsql-performance by date

  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