Database Reference
In-Depth Information
3
Coniguration
In this chapter, we will cover the following:
F
Reading the Fine Manual (RTFM)
F
Planning a new database
F
Changing parameters in your programs
F
The current configuration settings
F
Parameters that are at non-default settings
F
Updating the parameter file
F
Setting parameters for particular groups of users
F
Basic server configuration checklist
F
Adding an external module into PostgreSQL server
F
Running server in power saving mode
Introduction
I get asked many questions about parameter settings in PostgreSQL.
Everybody's busy and most people want the five minute tour of how things work. That's exactly
what a Cookbook does, so we'll do our best.
Some people believe that there are some magic parameter settings that will improve their
performance, spending hours combing the pages of topics to glean insights. Others already
feel comfortable because they found some website somewhere that "explains everything",
and they "know" they have their database configured OK.
For the most part, the settings are easy to understand. Finding the best setting can be
difficult, and the optimal setting may change over time in some cases. This section is
mostly about knowing how, when, and where to change parameter settings.
