Module 5 - Configuration

Module Objectives

Setting Server Parameters

The Server Parameter File - postgresql.conf

Ways to Set Server Parameters

ALTER SYSTEM

Demo - Changing Server Parameters

Connection Settings

Security and Authentication Settings

Memory Settings

Dynatune Dynamic Tuning

EDB Resource Manager

Query Planner Settings

Write Ahead Log Settings

Write Ahead Log Settings (Continued)

Where To Log

When To Log

What To Log

Background Writer Settings

Statement Behavior

Parallel Query Scan Settings

Vacuum Cost Settings

Autovacuum Settings

Configuration File Includes

Module Summary

Lab Exercise - 1

Lab Exercise - 2

Lab Exercise - 3

Lab Exercise - 4