I would recommend a separate pg_wal filesystem with the record size to match the WAL page size; in my case 16k. I have
keepthe default record size at 128k for the data volume and that configuration has worked well for supporting large DSS
whileusing 16k data blocks.
> On Mar 30, 2022, at 5:32 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
>
> 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
asto take advantage of compression, etc. One thing I haven't seen is whether a separate volume for WAL would benefit
froma larger recordsize. Or any other tweaks???
>
> --
> Scott Ribe
> scott_ribe@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>
