Pro PostgreSQL 9

Data: Relational
Location: Oregon Ballroom 204
Tags: sql, postgres, dba
Average rating: ***..
(3.50, 6 ratings)

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 workshop will be broken into two major sections:

1. Administration Best Practices

  • Installation
  • Upgrades
  • Configuration
  • Monitoring
  • Vacuum Strategies

2. 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.

Photo of Robert Treat

Robert Treat


With more than fifteen years of experience building database backed, internet based systems at multiple fortune 500 companies, Robert is now CEO of OmniTI, a technical services firm focused on providing web application development and infrastructure management at scale. Author and speaker at conferences worldwide, Robert is a recognized expert within the industry on topics such as Open Source, databases, and managing operations at scale. He occasionally blogs at

Comments on this page are now closed.


Picture of Jose Urzua
Jose Urzua
07/27/2011 7:05am PDT

22 minutes for describing the project! too much!