PostgreSQL administration and performance tuning COMPACT

Duration:3 Days
Level:Intermediate
Price:contact us today
Audience:This course is especially suitable for database administrators (Linux / Windows / Solaris / Mac OS X) and sysadmis, with less time, who cannot attend the 5 days training.
Date:14th – 16th October 2013 (in German; English on request)

 

Day 1:

Installing PostgreSQL

  • Creating database instances
  • Creating databases
  • Encoding issues

Using indexes

  • Simple btree indexes
  • The PostgreSQL optimizer
  • Full Text search
  • Fuzzy search

Day 2:

Understanding transactions

  • Concurrency issues
  • Using savepoints
  • PostgreSQL locking behavior
  • Transaction isolation

MVCC and space management

  • Understanding MVCC
  • PostgreSQL disk layout
  • VACUUM: Reclaiming space
  • Autovacuum

PostgreSQL monitoring

  • Understanding PostgreSQL system tables
  • PostgreSQL system statistics
  • Creating logfiles

Windowing and analytics

  • Analyzing data
  • Using analytics

Day 3:

PostgreSQL performance tuning

  • Tweaking checkpoints
  • Configuring shared_buffers
  • Additional memory parameters

Backup and recovery

  • Running backups
  • Configuring Point-In-Time-Recovery

Utilizing replication

  • Streaming replication
  • Synchronous and asynchronous replication
  • High-Availability considerations

PostgreSQL stored procedures

  • Writing SQL functions
  • Using PL/pgSQL
  • Working with triggers