PostgreSQL Professional

LEVEL: Intermediate
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.
Book Now

Course Topics

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
  • Extended Statistics

Course INFO

Level Intermediate

Knowledge needed.


English or German


3 Days

Location & Date

Currently there is no date and time available for this certain training, if you are interested please contact us.
Contact us
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf

+43 (0) 2622 93022-0

Get the newest PostgreSQL Info & Tools

    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram