• 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


Working on database backed, internet based systems for over a decade, Robert is co-author of the book Beginning PHP and PostgreSQL 8, maintains the phpPgAdmin software package, and has been recognized as a major contributor to the PostgreSQL project for his work over the years. An international speaker on databases, open source, and managing web operations at scale, he spends his days as CEO of OmniTI, perhaps the best technology consulting firm on the planet.

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!