| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Nikolas Everett <nik9000(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: SAN and full_page_writes |
| Date: | 2008-09-08 22:35:24 |
| Message-ID: | 200809082235.m88MZOb09974@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Smith | 2008-09-08 23:12:24 | Intel's X25-M SSD |
| Previous Message | Scott Marlowe | 2008-09-08 16:36:00 | bitmap heap scan versus simple index and nested loop |