Postgres Pro
Downloads
Home   >   mailing lists

WAL & ZFS - Mailing list pgsql-admin

From Scott Ribe
Subject WAL & ZFS
Date
Msg-id FC215502-166A-49DB-B3DA-D08727A34C0B@elevated-dev.com
Whole thread Raw
Responses Re: WAL & ZFS  (Rui DeSousa <rui@crazybean.net>)
Re: WAL & ZFS  (Mladen Gogala <gogala.mladen@gmail.com>)
List pgsql-admin
Tree view 
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/

pgsql-admin by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Vacuum behaviour for replicated nodes with pglogical (postgres 10)
Next
From: Rui DeSousa
Date:
Subject: Re: WAL & ZFS