O'Reilly Open Source Convention
Books Safari Bookshelf Conferences O'Reilly Network

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow Wiki
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Tips for
Arrow Press
Arrow Mail List



Setting up a Large PostgreSQL Server: A Case Study
Vivek Khera, MailerMailer, LLC

Track: PostgreSQL
Date: Wednesday, July 28
Time: 4:30pm - 5:15pm
Location: Salon D


PostgreSQL is the premiere open source relational database system. While setting it up is quite easy, configuring it to perform well with a large database and heavy load is not. Khera describes the process of configuring both the hardware and software for a server that replaced an older, underpowered system.

The process begins with selection of the hardware and continues with evaluation of RAID performance including selection of RAID configuration. With the hardware configured, attention turns to configuring the database server to load the existing data quickly, and then to maximizing performance during normal operations and ensuring various configurations are set appropriately. Finally, the continued maintenance is addressed by adjusting the parameters to the auto vacuum program.

Download presentation file

O'Reilly Home | Privacy Policy

© 2004, O'Reilly Media, Inc.