PostgreSQL Professional

This course takes 3 days – 8 hours per day (on site) or 5 hours per day (online).
The only difference is that there will be less practical exercises in an online course. However, we can share them with you so you can do them on your own. You can ask our consultants for feedback or help, if needed.

Day 1

• Installation
• Advanced psql
• Advanced indexing: Multi column indexes, GIN indexes, GiST indexes
• Full text search
• Exclusion Constraints
• Range data types
• Arrays and JSON in the database
• Transactions: isolation levels, serialization 
• Prepared transactions, two-phase commit

Day 2

• Physical Backup: Low-level API
• Autovacuum: advanced tuning
• Streaming replication
• Synchron replication
• Hot Standby and conflict management 
• Failover
• High Availability, Patroni
• Logical replication

Day 3

• Partitioning
• Parallel queries
• Foreign Data Wrapper
• Functions
• Statement tuning: finding slow statements
• EXPLAIN (ANALYZE, BUFFERS)
• Extended Statistics