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^® ^
>
>
> s(dot)froehlich(at)cablelabs(dot)com <mailto:s(dot)froehlich(at)cablelabs(dot)com>
>
> Tel: +1 (303) 661-3708
>
>  
>