PostgreSQL Administration and Performance Tuning

Level:

Intermediate

Duration:

5 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  >>

 

The training takes 4 days. In addition, a further day can be booked, during which we’ll address individual questions.

Audience

This course is especially suitable for database administrators (Linux / Windows / Solaris / Mac OS X) and sysadmins. We will deal with administration and performance tuning -related topics.

COURSE CONTENT

Day 1

  • The PostgreSQL project, support, community, release- and version management
  • Overview architecture
  • Installation, start and stop the server, connect to the client
  • Client “psql”
  • Indexing with B-Tree indexes
  • EXPLAIN
  • Transactions: Atomicity, Isolation, Locking


Day 2

  • Transactions: optimistic and pessimistic “locks”
  • Multiversioning
  • VACUUM
  • Autovacuum
  • Logical backup, data export and import (pg_dump)
  • physical backup, Transaction log archiving
  • Point-in-time Recovery


Day 3

  • Streaming Replication
  • Synchrone Replication
  • Hot Standby and conflict management
  • Failover
  • High Availability, concept of Patroni
  • User management, authentification
  • Remote access to the database
  • Permissions

Day 4

  • Configuration parameters
  • Logging
  • Resource management
  • Parameter tuning
  • Security
  • Upgrade
  • Statistics and monitoring
  • Statement tuning
  • EXPLAIN (ANALYZE, BUFFERS)
  • Extended Statistics

 

Contact us to sign up for this course >>