A PostgreSQL powered database environment will help you increasing the profitability of your business and will help you to achieve your business goals.

PostgreSQL Administration, Monitoring,
and Performance Tuning

"Teach on the Beach"
Location: Dominican Republic

During this 5 day training course you will learn about all important aspects of PostgreSQL administration, monitoring, and performance tuning.

This course will be held in a relaxed and open environment. Learning in small groups will make sure that you can benefit from this training in an efficient way.

Content of the training course:
The PostgreSQL architecture
Adjusting operating system parameters
Optimizing kernel settings
Tweaking filesystems

VACUUM
The purpose of VACUUM
Reclaiming space
Transaction wraparound
Reducing the impact of VACUUM
autovacuum

Monitoring
Detecting slow queries
Checking I/O performance
Monitoring caching
Detecting bottlenecks
Detecting bad locking behavior
Writing plugins for monitoring tools
Monitoring index and table sizes

Optimizing PostgreSQL
Optimizing caching
Optimizing storage
Fixing slow queries

Security
Creating roles
Adjusting user permissions
Limiting remote access
Using different methods of authentication

Backup and recovery
Performing backups
Partial backups
Disaster Recovery
Exporting data
Bulk Loading

High-Availability
Setting up Point-In-Time-Recovery
Replication concepts
HA concepts

Basic knowledge of SQL is required. It is recommended to be familiar with the UNIX command line interface.
The course will be held by Hans-Juergen Schoenig, a leading expert who has written 4 books on PostgreSQL. He has been in professional PostgreSQL business since 1999.

Register for this training now: email

Price: USD 2.100
Early Bird: USD 1.900

<< back