Schedule - PGConf.EU 2018
File system and virtual memory tuning for a Zabbix database
Date: 2018-10-25
Time: 15:40–16:30
Room: Berlin
Level: Intermediate
The file systems offer a lot of tunables. PostgreSQL relies heavily on the operating system and file systems is running on. But what's the exact impact of those parameters on a real production database? In my presentation I'll show the test results done for one of our customer's using many terabytes Zabbix system with PostgreSQL as a backend. The following tunables (among others) were checked:
- file system block size
- write barriers
- journaling modes
- IO Schedulers
- access time
- read-ahead
- disk layouts
Two of the most widely used file systems: ext4 and xfs were investigated. Tests were conducted on 4 socket, 128GB RAM HP ProLiant DL580 G7 server, using pgreplay against Zabbix PostgreSQL 10 database.
Slides
The following slides have been made available for this session:
