Pro PostgreSQL 9

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.

People planning to attend this session also want to see:

Robert Treat

OmniTI

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 http://xzilla.net.