Conference 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:

Speaker

Alicja Kucharczyk