Re: WAL and O_DIRECT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ravi Krishna <s(dot)ravikrishna(at)aim(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL and O_DIRECT
Date: 2015-05-14 16:25:28
Message-ID: 4614.1431620728@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Ravi Krishna <s(dot)ravikrishna(at)aim(dot)com> writes:
> Am I right in concluding that PG WAL writes without underlying h/w caching is not crash proof.

We expect that the hardware+OS honors fsync() correctly, ie puts the data
on durable storage before fsync returns. That does not mean anything one
way or the other about caching, it just means that the filesystem stack
has to be correctly implemented.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2015-05-14 16:26:10 Re: WAL and O_DIRECT
Previous Message Ravi Krishna 2015-05-14 16:07:04 Re: WAL and O_DIRECT