• Intel
  • Microsoft
  • Google
  • Sun Microsystems
  • BT
  • IBM
  • Yahoo! Inc.
  • Zimbra
  • Atlassian Software Systems
  • Disney
  • EnterpriseDB
  • Etelos
  • Ingres
  • JasperSoft
  • Kablink
  • Linagora
  • MindTouch
  • Mozilla Corporation
  • Novell, Inc.
  • Open Invention Network
  • OpSource
  • RightScale
  • Silicon Mechanics
  • Tenth Planet
  • Ticketmaster
  • Voiceroute
  • White Oak Technologies, Inc.
  • XAware
  • ZDNet

Sponsorship Opportunities

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

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for more 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 Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the OSCON newsletter (login required).

Contact Us

View a complete list of OSCON 2008 Contacts

Pro PostgreSQL

Databases, Tutorial
Location: Portland 256 Level: Intermediate
Presentation: Pro PostgreSQL Presentation [ODP]
Average rating: ***..
(3.92, 13 ratings)

While you can run PostgreSQL without a lot of overhead, to get the most benefit from it you need to have full understanding of its feature set and how to tune and configure the system for maximum performance. In this tutorial we’ll take you beyond the basics and give you the information you need to go from just another user to serious PostgreSQL professional.

This tutorial will be broken into two major sections:

Administration Best Practices

  • Installation
  • Upgrades
  • Configuration
  • Routine Maintenance
  • Replication / High availability

Managing Database Use (and abuse)

  • Query Level Optimization
  • Advanced Indexing
  • Tablespaces
  • Partitioning

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


Robert Treat works as a database architect at OmniTI and has been working with open source for almost a decade. A veteran industry speaker, 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.

OSCON 2008