Monday, December 10

Tag: full_page_writes

PG Phriday: Postgres on ZFS

Shaun's PlanetPostgreSQL
ZFS is a filesystem originally created by Sun Microsystems, and has been available for BSD over a decade. While Postgres will run just fine on BSD, most Postgres installations are historically Linux-based systems. ZFS on Linux has had much more of a rocky road to integration due to perceived license incompatibilities. As a consequence, administrators were reluctant or outright refused to run ZFS on their Linux clusters. It wasn't until OpenZFS was introduced in 2013 that this slowly began to change. These days, ZFS and Linux are starting to become more integrated, and Canonical of Ubuntu fame even announced direct support for ZFS in their 16.04 LTS release. So how can a relatively obscure filesystem designed by a now-defunct hardware and software company help Postgres? Let's find out! (more…)