u/Best-Condition-5784

▲ 5 r/zfs

Postgres workload - SLOG Disk vs WAL Disk

English isn’t my first language, so please excuse any awkward phrasing.

With the setup shown below, I’m unsure whether it would be better to use one Optane mirror set for SLOG, or dedicate it exclusively for WAL.

I’ll be running an API server and various services on a Proxmox host, along with a PostgreSQL database.

https://preview.redd.it/cd81hcujkgvg1.png?width=626&format=png&auto=webp&s=2f917eb5f0ec20550b1fe2215a0fdb0bbf52cf58

Disk Capacity File System Purpose
P4800X 0.4 ZFS WAL Mirror vs SLOG Mirror
P4800X 0.4 ZFS WAL Mirror vs SLOG Mirror
P4800X 0.4 ZFS Special VDEV Mirror
P4800X 0.4 ZFS Special VDEV Mirror
PM1733 3.84 ZFS OS/VM/Etc... Mirror
PM1733 3.84 ZFS OS/VM/Etc... Mirror
reddit.com
u/Best-Condition-5784 — 8 days ago