Postgresql conference sessions

5:15pm–6:00pm Wednesday, 04/13/2011
While databases are increasingly being distributed across multiple nodes, the performance of every node still matters--especially if you're considering virtualized or cloud deployments that have their own specific trade-offs. Memory performance scaling as core count changes, all aspects of disk performance, and using sysbench to benchmark both MySQL and PostgreSQL are all topics covered here.
11:55am–12:40pm Tuesday, 04/12/2011
Has your database grown to hundreds of gigabytes in size, with no limit in sight? Are you considering moving to an expensive proprietary database system do deal with your huge database? PostgreSQL is an excellent database for small to medium sized data warehouses in the 0.5 to 5 terabyte range.
9:00am–12:30pm Monday, 04/11/2011
Want to really scale PostgreSQL using the new binary replication? Learn how to set up hot standby, streaming replication, failover, non-persistant databases and cloning to scale PostgreSQL 9 for reads.
5:15pm–6:00pm Tuesday, 04/12/2011
PostgreSQL is highly customizable, but which settings are most important and what values are most appropriate for a typical installation? This talk will explain the basics of how to configure PostgreSQL for reliability and good performance.
11:55am–12:40pm Wednesday, 04/13/2011
Size can creep up on you. Some day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow, and find out what new features in 9.0 have made life easier for administrators and application developers working with big data.
11:55am–12:40pm Wednesday, 04/13/2011
Mixed SQL system environments are a reality for most organizations. MySQL and PostgreSQL are a natural combination -- both are open source, and they complement each other nicely. See how to improve data consolidation, increase confidence in query results, and analyze data across applications.
2:00pm–3:00pm Wednesday, 04/13/2011
OpenStreetMap raw data for any non-trivial area comes as a massive amount of XML data. Processing that XML data directly is possible, importing it into into a spatial database provides for much more interesting processing options though, especially when it comes to producing on demand map data for web applications with acceptable performance.
3:05pm–3:50pm Tuesday, 04/12/2011
This talk explores the ways attackers with no authorized database access can steal Postgres passwords, see database queries and results, and even intercept database sessions and return false data. Postgres supports features to eliminate all of these threats, but administrators must understand the attack vulnerabilities to protect against them.
3:05pm–3:50pm Wednesday, 04/13/2011
As CTO of, and in my new stealth company, I've seen my share of challenging scenarios keeping a very busy PostgreSQL-based startup online and responsive during tremendous growth. EC2 + PostgreSQL + PostGIS + no downtime. Others can probably learn from my battle scars!
  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Media Partners Opportunities

For media partnerships, contact mediapartners@

Press & Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts