Re: Revisiting disk layout on ZFS systems

From: Karl Denninger <karl(at)denninger(dot)net>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Revisiting disk layout on ZFS systems
Date: 2014-04-28 18:29:29
Message-ID: 535E9E09.1050502@denninger.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On 4/28/2014 1:26 PM, Jeff Janes wrote:
> On Mon, Apr 28, 2014 at 11:07 AM, Karl Denninger <karl(at)denninger(dot)net
> <mailto:karl(at)denninger(dot)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(at)denninger(dot)net

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2014-04-28 20:41:16 Re: Checkpoints and slow queries
Previous Message Karl Denninger 2014-04-28 18:27:07 Re: Revisiting disk layout on ZFS systems