PostgreSQL Professional

Level:

Intermediate

Duration:

3 days

Dates & Duration

See available dates for this course!
If there is no date and time available for a certain training you are interested in, please contact us.

See dates  >>

 

This training can also be held at your place or as online training especially for your company. In this case the course agenda can also be adapted to suit your needs best.

Learn more about our customized training >>

 

This course takes 3 days with 8 hours each (on site) or 5 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.

Audience

This course provides a deep insight into advanced PostgreSQL topics like indexing, storage parameters, optimization, replication, monitoring, etc. It covers the technical foundations required for replication, scaling, point-in-time recovery, and the successful operation of synchronous and asynchronous replication solutions. Moreover, details of processing that are essential for optimization and performance tuning are highlighted, so that you can get the most out of your system and queries.

Available Languages

This course can be held in English, German, Spanish, Estonian, Polish, Ukrainian and Russian.

Content

Day 1

  • Installation
  • Advanced psql
  • Advanced indexing: Multi column indexes, GIN indexes, GiST indexes
  • full text serach
  • 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 Konfliktmanagement
  • 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

 

Contact us to sign up for this course >>