Course Code:
psgsql
Duration:
28 hours
Prerequisites:
-
Overview:
-
Course Outline:
Performance Tuning
- Operating System Best Practices
- Server Parameter Tuning
- Extension – pg_stat_statements
- Demo and Labs
Benchmarking
- Database Benchmarking
- Pgbench
- Reading the Results
- Demo and Labs
- Setting Permissions & Security
- Querying the Database
- Monitoring the Database
- Ensuring Atomicity and Isolation
- Backing up and Restoring PostreSQL
- Migrating Data to Another System
- Working with PostreSQL Logs
Performance Optimization
- ·Reducing I/O with HOT
- ·Locking & Concurrency
- ·Evaluating the Design of the Database
- ·Optimizing SQL Queries with EXPLAIN
- ·Inspecting the Workload
- ·Benchmarking and Profiling
- ·Optimzing Joins
- ·Using Indexes Efficiently
PostgreSQL Replication
- ·Overview of PostgreSQL Replication
- ·High Availability in PostgreSQL
- ·Streaming Replication
- ·Managing Clusters Using repmgr
- ·Running Queries on Database in Hot Standby
- ·Synchronous Replication
- ·File based Log Shipping
- ·Trigger-based Logical Replication with Slony & Londiste
- ·Connection Pooling
- ·Upgrading PostgreSQL
- ·Sharding and Scaling PostgreSQL