Re: WAL on zfs Settings

Hi, Stephen.

I also use PostgreSQL with a ZFS filesystem (FreeBSD). Will you describe
your ZFS setup and the relevant parts of your postgresql.conf?


On 1/4/19 8:24 AM, Stephen Froehlich wrote:
> 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, *Cable*Labs^® ^
> 
> 
> [email protected] <mailto:[email protected]>
> 
> Tel: +1 (303) 661-3708
> 
>  
>