How do you choose the right filesystem for your database management system? Administrators have a variety of filesystems to choose from, as well as volume management and hardware or software RAID. This talk will examine how different the performance of filesystems really are, and how do you go about systematically determining which configuration will be the best for your application and hardware.
This talk will present data generated by a group of volunteers running performance tests for database tuning. We were curious if the file systems would really behave like we expected them to, especially when used in conjunction with RAID or volume management.
There is also more to file systems than how fast we can read to or write to them. Reliability is critical for production environments, and proving that is a key part of evaluating performance.
The talk will review and confirm or deny assumptions that many system administrators and developers make about filesystems and databases.
Data shared will include baseline throughput determined with exhaustive fio tests, and data from recent tests that are Postgres specific. We’re using DBT-2, a TPC-C fair use derivative.
Selena Deckelmann is a Software Engineer at End Point Corporation. She is co-chair of Open Source Bridge, a Portland conference dedicated to open source developers. She is User Group Liaison for the PostgreSQL Global Development Group. She currently leads PDXPUG, a PostgreSQL Users Group, and helps operate a programming group, Code-n-Splode, whose goal is to get more women involved in open source development. In her spare time, she collects eggs from her chickens, gardens and occasionally mixes drinks for her local Perl Mongers group.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the OSCON Sponsor/Exhibitor Prospectus
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 OSCON newsletter (login required)
View a complete list of OSCON contacts