Postgres Pro
Downloads
Home   >   mailing lists

WAL on zfs Settings - Mailing list pgsql-novice

From Stephen Froehlich
Subject WAL on zfs Settings
Date
Msg-id DM5PR06MB3436542F94094CDA590D2013E58E0@DM5PR06MB3436.namprd06.prod.outlook.com
Whole thread Raw
Responses Re: WAL on zfs Settings
List pgsql-novice
Tree view

I am rebuilding my database server, and one of the novice mistakes I made the first time around is not creating distinct zfs filesystems for different tablespaces and of course the WAL. The database is for analysis work, which often means large data load-ins.  (Backups are purely occasional pg_dumps.)

 

My question is what are the optimal zfs settings for the WAL filesystem (block size, who does compression, etc.)?  The underlying hardware will be 3 NVME SSDs in a raidz configuration.  (I do already know that I can turn off full_page_writes for WAL on zfs.)

 

Thanks,

Stephen

 

Stephen Froehlich
Sr. Strategist, CableLabs®


s.froehlich@cablelabs.com

Tel: +1 (303) 661-3708

 

pgsql-novice by date:

Previous
From: Jay Riddle
Date:
Subject: Re: configure postgtresql to order NULLS FIRST instead of thedefault NULLS LAST
Next
From: "Vianello, Daniel A"
Date:
Subject: RE: configure postgtresql to order NULLS FIRST instead of the defaultNULLS LAST