Re: Revisiting disk layout on ZFS systems - Mailing list pgsql-performance

From Karl Denninger
Subject Re: Revisiting disk layout on ZFS systems
Date
Msg-id 535E9E09.1050502@denninger.net
Whole thread Raw
In response to Re: Revisiting disk layout on ZFS systems  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance

On 4/28/2014 1:26 PM, Jeff Janes wrote:
On Mon, Apr 28, 2014 at 11:07 AM, Karl Denninger <karl@denninger.net> wrote:


Isn't WAL essentially sequential writes during normal operation?

Only if you have some sort of non-volatile intermediary, or are willing to risk your data integrity.  Otherwise, the fsync nature trumps the sequential nature.

That would be a "no" on the data integrity :-)

-- 
-- Karl
karl@denninger.net
Attachment

pgsql-performance by date:

Previous
From: Karl Denninger
Date:
Subject: Re: Revisiting disk layout on ZFS systems
Next
From: Tomas Vondra
Date:
Subject: Re: Checkpoints and slow queries