CYBERTEC PostgreSQL Logo

PostgreSQL Professional

LEVEL: Expert
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
  • EXPLAIN (ANALYZE, BUFFERS)
  • Extended Statistics

Course INFO

Level Expert

Language

English or German

Duration

Location & Date

Contact us
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

Get the newest PostgreSQL Info & Tools


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

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