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.
The major topics will be:
1. Making sure that your data will survive an operating system crash.
2. Adjust memory usage parameters for optimal performance.
3. A quick and dirty guide to tuning the query planner.
4. Additional performance considerations for large systems.
Robert Haas is a PostgreSQL hacker and enthusiast who has been using and enjoying PostgreSQL for more than 10 years. Beginning in late 2008, he became active in the PostgreSQL development effort as a patch reviewer and CommitFest manager. In December 2009, he became a PostgreSQL committer, and in April 2010, he joined EnterpriseDB as a Database Architect.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
For media-related inquiries, contact Maureen Jennings at email@example.com
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).
View a complete list of O'Reilly MySQL Conference Contacts