> > That can definitly be debated. Properly maintaned on proper > hardware, > > it's quite reliable these days. > > Most filesystem corruptions that happen on windows are > because people > > enable write caching on drives without battery backup. The > same issue > > we're facing here, it's *not* a problem in the fs, it's a > problem in > > the admin. Sure, there are lots of things that could be better with > > ntfs, but I would definitly not call it unreliable. > > People enable? Isn't it the default?
I dunno about workstation OS, but on the server OSes it certainly isn't default. > > > 3. The probability of mediocre hardware is higher. > > > > I would say it's actually *lower*. If you look in the average > > datacenter, I bet you'll find a lot more linux boxes running on > > built-at-home-with-the-cheapest-parts boxes. Whereas your windows > > boxes will run on HP or IBM or whatever real server-grade hardware. > > > > I don't know anybody who claims to run a professional business who > > uses IDE drives in a Windows server, for example. I know > several who > > run linux or freebsd on it. > > The professional probably tests it on his own desktop. I > don't think PostgreSQL reaches the data center before passing > the run on desktop. I can't speak for others, but I would always test a server product on a server OS on server hardware. Certainly not as beefy as eventual production server, but the same level. Otherwise the test is not fully relevant. > > > Why shouldn't we offer reliable option to win32? > > > > *we do offer a reliabel option*. > > Same as on POSIX, we don't enable it by default for *non-server > > hardware*. > > What do you mean here? AFAIK we try to be reliable on POSIX too. AFAIK fsync is slightly safer than open_sync, because it also flushes the metadata. We don't default to that. > > > Options: > > > > > > - Win32 guy complains that PG is bit slow. > > > We tell him to RTFM. > > > > What most often happens here is: > > Win32 guy notices PG is very slow, changes to mysql or mssql. > > But lost database is no problem? > It certainly is. That's not what I'm arguing. What I'm saying is that you shouldn't expect server grade reliabilty on desktop hardware and desktop OS. Regardless of platform. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
