| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Document how to turn off disk write cache on popular operating |
| Date: | 2007-12-11 15:13:58 |
| Message-ID: | 20071211151358.GP31937@svr2.hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers pgsql-hackers |
On Tue, Dec 11, 2007 at 10:09:51AM -0500, Tom Lane wrote:
> Magnus Hagander <magnus(at)hagander(dot)net> writes:
> > If you set it to fsync or fsync_writethrough it will write through the
> > cache.
>
> Really? How much should we trust that?
I'd say as much as we shuold trust that checkbox in the Windows settings
page...
I haven't come across a case yet where it doesn't work, but that doesn't
mean there isn't one. It certainly writes through the writeback cache of
shiny expensive raid controllers :-) And it does write through the IDE
drives that I've tested.
Bottom line is, I think that the cases where fsync_writethrough doesn't do
it, that checkbox isn't going to work either....
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-12-11 15:19:05 | pgsql: Extend the format of CSV logs to include the additional |
| Previous Message | Tom Lane | 2007-12-11 15:09:51 | Re: Document how to turn off disk write cache on popular operating |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-12-11 15:14:30 | Re: WORM and Read Only Tables (v0.1) |
| Previous Message | Tom Lane | 2007-12-11 15:09:51 | Re: Document how to turn off disk write cache on popular operating |