PostgreSQL + ZFS: Best Practices and Standard Procedures

Описание

Sean Chittenden, Engineer from Joyent delivers their talk, "PostgreSQL + ZFS: Best Practices and Standard Procedures", on DAY 1 of the Percona Live Open Source Database Conference 2017, 4/25, at Santa Clara, CA.

PostgreSQL and ZFS were made for each other. This talk dives downstack into the
internals and way that PostgreSQL consumes disk resources and tricks that are
available if you run PostgreSQL on ZFS (ZFS on Linux, ZFS on FreeBSD, or ZFS on
Illumos).

Topics covered will include:

*) Performance and sizing considerations
*) Workload estimation heuristics
*) Standard administrative practices that leverage ZFS
*) Recovery using ZFS
*) Performing database migrations using ZFS
*) PITR of databases using ZFS