O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Configuration

In this chapter, we will cover the following:

  • Reading the Fine Manual (RTFM)
  • Planning a new database
  • Changing parameters in your programs
  • The current configuration settings
  • Parameters that are at non-default settings
  • Updating the parameter file
  • Setting parameters for particular groups of users
  • Basic server configuration checklist
  • Adding an external module into PostgreSQL server
  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required