From: Scott Ribe <scott_ribe@elevated-dev.com>
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: WAL & ZFS
Date: Wed, 30 Mar 2022 15:32:36 -0600
Message-ID: <FC215502-166A-49DB-B3DA-D08727A34C0B@elevated-dev.com> (raw)
I've read all the info I could find re running PG on ZFS: turn off full page writes, turn on lz4, tweak recordsize so as to take advantage of compression, etc. One thing I haven't seen is whether a separate volume for WAL would benefit from a larger recordsize. Or any other tweaks???
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, pgsql-admin@lists.postgresql.org
Subject: Re: WAL & ZFS
In-Reply-To: <FC215502-166A-49DB-B3DA-D08727A34C0B@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox