Tweaking XFS performance
When it comes to performance optimization on XFS filesystems, allocation groups are only the beginning. To maintain a high-availability PostgreSQL server, we want to get the most out of XFS. For us, this means using specific mount options.
Thankfully, unlike formatting, mount options can be changed frequently and require very little downtime. Though it isn't essential that we apply these values immediately, the options discussed in this recipe are our recommendation for this stack.
Getting ready
In order to mount an XFS filesystem, we need one to exist. Please follow the recipe contained in Formatting an XFS Filesystem before continuing.
How to do it...
Assuming pg1 is our current primary node, follow these steps as the root ...
Get PostgreSQL 9 High Availability Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
