Percona Live 2017 Open Source Database Conference

April 24 - 27, 2017

Santa Clara, California

PostgreSQL + ZFS: Best Practices and Standard Procedures

PostgreSQL + ZFS: Best Practices and Standard Procedures

 25 April - 5:15 PM - 5:40 PM @ Room 203
Experience level: 
Intermediate
Duration: 
25 minutes conference
Tracks:
Operations
Topics:
PostgreSQL
Data in the Cloud
Replication

Description

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

Speakers

Sean Chittenden

Engineering, Joyent

Biography:

Database nerd

Share this talk