Re: [PERFORM] Lying drives [Was: Re: Which OS provides the

2006-11-23 Thread Bruce Momjian
Greg Smith wrote: > On Mon, 13 Nov 2006, Guy Thornley wrote: > > > I've yet to find a drive that lies about write completion. The problem > > is that the drives boot-up default is write-caching enabled (or perhaps > > the system BIOS sets it that way). If you turn an IDE disks write cache > > o

Re: [PERFORM] Lying drives [Was: Re: Which OS provides the _fastest_

2006-11-22 Thread Greg Smith
On Mon, 13 Nov 2006, Guy Thornley wrote: I've yet to find a drive that lies about write completion. The problem is that the drives boot-up default is write-caching enabled (or perhaps the system BIOS sets it that way). If you turn an IDE disks write cache off explicity, using hdparm or similar

Re: [PERFORM] Lying drives [Was: Re: Which OS provides the _fastest_ PostgreSQL performance?]

2006-11-13 Thread Guy Thornley
> > That's not quite what I meant by "trust". Some drives lie about the > > flush. > > Is that really true, or a misdiagnosed software bug? I've yet to find a drive that lies about write completion. (*) The problem is that the drives boot-up default is write-caching enabled (or perhaps the syst

[PERFORM] Lying drives [Was: Re: Which OS provides the _fastest_ PostgreSQL performance?]

2006-11-10 Thread Ron Mayer
toby wrote: > > That's not quite what I meant by "trust". Some drives lie about the > flush. Is that really true, or a misdiagnosed software bug? I know many _drivers_ lie about flushing - for example EXT3 on Linux before early 2005 "did not have write barrier support that issues the FLUSH CACH