Duration
2 days
Overview
You will learn about optimization, bottleneck detection, backup and recovery, replication, logfile management, indexing, and much more in a systematic and carefully structured manner. This invaluable course will enable you to develop the fundamental skills required to deploy PostgreSQL in order to efficiently manage your databases.
Chapter 1: Installing PostgreSQL
- Preparing your setup
- Understanding the existing databases
- Creating databases
Chapter 2: Indexing and Performance Tuning
- Using simple binary trees
- Understanding the concept of execution plans
- Dealing with different types of indexes
- Detecting missing indexes
- Detecting slow queries
- Adjusting memory parameters
Chapter 3: Users and Permissions
- Understanding PostgreSQL security
Chapter 4: Managing Logfiles
- Understanding the PostgreSQL log architecture
- Configuring the amount of log output
- Making log creation more fine grained
Chapter 5: Backup and Recovery
- Importing and exporting data
- Performing backups
Chapter 6: Handling Replication and Improving Performance
- Understanding the PostgreSQL transaction log
- Configuring the checkpoints
- Setting up an asynchronous replication
- Upgrading to synchronous replication
- Improving and monitoring the replication
- Handling point-in-time recovery
- Understanding timelines
Chapter 7: Monitoring PostgreSQL
- Understanding the system statistics of PostgreSQL
- Integrating Nagios
- Handling Linux cgroups
Programme scope, delivery arrangements and suitability are confirmed during enquiry.