• 10gen
  • DataStax, Inc.
  • Dell
  • Google
  • Lexis Nexis
  • Oracle
  • VMware
  • Percona

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the convention, contact Sharon Cordesse at scordesse@oreilly.com

Download the OSCON Data Sponsor/Exhibitor Prospectus

Media Partner Opportunities

For information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

OSCON Bulletin

To stay abreast of convention news and announcements, please sign up for the OSCON email bulletin (login required)

Contact Us

View a complete list of OSCON contacts

Pro PostgreSQL 9

Robert Treat (OmniTI)
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, managing operations at scale. He occasionally blogs at http://xzilla.net.

Comments on this page are now closed.


Picture of Jose Urzua
Jose Urzua
07/27/2011 2:05pm PDT

22 minutes for describing the project! too much!