PostgreSQL + ZFS: Best Practices and Standard Procedures


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
Room 106
Thursday, March 2, 2017 - 11:00 to 12:00