PostgreSQL administration and performance tuning COMPACT
Duration: | 3 Days |
Level: | Intermediate |
Price: | contact us today |
Audience: | This course is especially suitable for database administrators (Linux / Windows / Solaris / Mac OS X) and sysadmis, with less time, who cannot attend the 5 days training. |
Date: | 14th – 16th October 2013 (in German; English on request) |
Day 1:
Installing PostgreSQL
- Creating database instances
- Creating databases
- Encoding issues
Using indexes
- Simple btree indexes
- The PostgreSQL optimizer
- Full Text search
- Fuzzy search
Day 2:
Understanding transactions
- Concurrency issues
- Using savepoints
- PostgreSQL locking behavior
- Transaction isolation
MVCC and space management
- Understanding MVCC
- PostgreSQL disk layout
- VACUUM: Reclaiming space
- Autovacuum
PostgreSQL monitoring
- Understanding PostgreSQL system tables
- PostgreSQL system statistics
- Creating logfiles
Windowing and analytics
- Analyzing data
- Using analytics
Day 3:
PostgreSQL performance tuning
- Tweaking checkpoints
- Configuring shared_buffers
- Additional memory parameters
Backup and recovery
- Running backups
- Configuring Point-In-Time-Recovery
Utilizing replication
- Streaming replication
- Synchronous and asynchronous replication
- High-Availability considerations
PostgreSQL stored procedures
- Writing SQL functions
- Using PL/pgSQL
- Working with triggers