pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Holger Jakobs <holger@jakobs.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: WAL & ZFS
Date: Thu, 31 Mar 2022 16:58:08 -0600
Message-ID: <61E764EB-0038-4438-83D0-C50036FFB032@elevated-dev.com> (raw)
In-Reply-To: <35c98a4b-f7a1-a896-4484-582bbaaffb5b@jakobs.com>
References: <FC215502-166A-49DB-B3DA-D08727A34C0B@elevated-dev.com>
	<43EEBE2E-4C7F-4F35-99BF-4DA8B5D3828A@crazybean.net>
	<35c98a4b-f7a1-a896-4484-582bbaaffb5b@jakobs.com>

> On Mar 31, 2022, at 4:47 PM, Holger Jakobs <holger@jakobs.com> wrote:
> 
> The WAL is a journal itself and doesn't need another journal for safety. Therefore, a common recommendation is using ext2 (which has no journal) for the WAL partition.
> 
> Is this correct?

I could see that being reasonable. In this case I don't control number and size of drives, and have a layout where it's really best in terms of utilization to put them all into the zpool. So my options are limited to ZFS options.




view thread (13+ messages)  latest in thread

Message-ID: <61E764EB-0038-4438-83D0-C50036FFB032@elevated-dev.com>
Permalink:  ../61E764EB-0038-4438-83D0-C50036FFB032@elevated-dev.com/
Also on:    postgresql.org/message-id/61E764EB-0038-4438-83D0-C50036FFB032@elevated-dev.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: scott_ribe@elevated-dev.com, holger@jakobs.com, pgsql-admin@lists.postgresql.org
  Subject: Re: WAL & ZFS
  In-Reply-To: <61E764EB-0038-4438-83D0-C50036FFB032@elevated-dev.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox