Re: SAN and full_page_writes - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: SAN and full_page_writes
Date
Msg-id 200809082235.m88MZOb09974@momjian.us
Whole thread Raw
In response to Re: SAN and full_page_writes  ("Nikolas Everett" <nik9000@gmail.com>)
List pgsql-performance
Nikolas Everett wrote:
> Thanks for pointing that out Bruce.
>
> NetApp has a 6 page PDF about NetApp and databases.  On page 4:
>
> As discussed above, reads and writes are unconditionally atomic to 64 KB.
> While reads or writes
> may fail for a number of reasons (out of space, permissions, etc.), the
> failure is always atomic to
> 64 KB. All possible error conditions are fully evaluated prior to committing
> any updates or
> returning any data to the database.

Well, that is certainly good news, and it is nice the specified the atomic
size.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: bitmap heap scan versus simple index and nested loop
Next
From: Greg Smith
Date:
Subject: Intel's X25-M SSD