Pro PostgreSQL 9

Training type: 
Half day training
Track: 
Administration
Technical Level: 
Beginner

From start-ups to large enterprise shops, more and more people are using Postgres. Whether as a self-running data store, or to handle more complex OLTP, OLAP, and mixed database workloads, Postgres offers a lot of functionality and flexability. What it doesn’t offer is a road map of how to go beyond the basics and get the information you need to go from just another user to serious PostgreSQL professional.

This tutorial will be broken into two major sections (roughly):

Administration Best Practices

  • Installation
  • Upgrades
  • Configuration
  • Monitoring
  • Vacuum Strategies

    Managing Database Use (and abuse)

  • Failover and Backups
  • Scale-out (replication)
  • Query Level Optimization
  • Indexing
  • 9.1 Highlights

    Whether you’re a DBA or developer, you’ll get plenty of information to incorporate into your day-to-day operations. Data is your company’s most valuable asset, so what could be more valuable than getting the most from your database system.