Город МОСКОВСКИЙ
00:43:00

PostgreSQL + ZFS: Best Practices and Standard Procedures

Аватар
Python улучшение
Просмотры:
35
Дата загрузки:
04.12.2023 01:10
Длительность:
00:43:00
Категория:
Технологии и интернет

Описание

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

Рекомендуемые видео