Re: WAL and O_DIRECT

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Ravi Krishna <s(dot)ravikrishna(at)aim(dot)com>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL and O_DIRECT
Date: 2015-05-14 15:53:38
Message-ID: 20150514155338.GA23739@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, May 14, 2015 at 11:32:12AM -0400, Ravi Krishna wrote:
> Aha that pretty much explains it. Yes we are using streaming replication.
>
> However our DB2 folks are raising a concern that PG WAL writes may not be crash
> safe, unless we are using write back technology in SAN or SSD , which we are
> using.

We write WAL to the kernel, then issue fsync.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ Everyone has their own god. +

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2015-05-14 15:55:33 Re: WAL and O_DIRECT
Previous Message Ravi Krishna 2015-05-14 15:32:12 Re: WAL and O_DIRECT