Time: 15:40 - 16:30
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:
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.