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.froehlich@cablelabs.com <mailto:s.froehlich@cablelabs.com>
>
> Tel: +1 (303) 661-3708
>
>
>