Re: [HACKERS] Write cache

2004-01-31 Thread Bruce Momjian
Andrew Dunstan wrote: > > > Tom Lane wrote: > > >Andreas Pflug <[EMAIL PROTECTED]> writes: > > > > > >>This would be the first time a SCSI disk lies about its write caching. > >>There are plenty of low-cost (i.e. IDE) disks out there having a hidden > >>write cache, but AFAIK a generic SCSI

Re: [HACKERS] Write cache

2004-01-31 Thread Andrew Dunstan
Tom Lane wrote: Andreas Pflug <[EMAIL PROTECTED]> writes: This would be the first time a SCSI disk lies about its write caching. There are plenty of low-cost (i.e. IDE) disks out there having a hidden write cache, but AFAIK a generic SCSI tool is usable to enable/disable the write cache.

Re: [HACKERS] Write cache

2004-01-31 Thread ohp
On Tue, 27 Jan 2004, Larry Rosenman wrote: > >> >> > >> >> ISTM that the driver should force it out to the disk, unless the disk > >> >> is lying to the driver, or the driver is buggy. > >> > That's exactly what I think: the DISK has a write cache so it's lying > >> > to the controler saying data i

Re: [HACKERS] Write cache

2004-01-31 Thread Larry Rosenman
--On Tuesday, January 27, 2004 23:15:09 +0100 [EMAIL PROTECTED] wrote: On Tue, 27 Jan 2004, Larry Rosenman wrote: >> >> >> >> ISTM that the driver should force it out to the disk, unless the >> >> disk is lying to the driver, or the driver is buggy. >> > That's exactly what I think: the DISK has

Re: [HACKERS] Write cache

2004-01-28 Thread Greg Stark
"Simon Riggs" <[EMAIL PROTECTED]> writes: > In the past, I have used the dd command to squirt data at the disk, then > read it back again - but there may be reasons I don't know why a success on > that test might not be conclusive, so I personally would be happy to defer > to someone that does.

Re: [HACKERS] Write cache

2004-01-28 Thread Simon Riggs
> Olivier PRENANT writes... > > Because I've lost a lot of data using postgresql (and I know for sure this > should'nt happen) I've gone a bit further reading documentations on my > disks and... > The bottom line here is that Olivier has lost some data and I'm sure we all want to know if there i

Re: [HACKERS] Write cache

2004-01-28 Thread scott.marlowe
On Wed, 28 Jan 2004 [EMAIL PROTECTED] wrote: > I agree I MAY have an hardware problem. What happens is more a system > freeze than a system crash (there's no panic, no nothing, just freezes, no > disk activity, not network) I would suspect either bad hardware,a flakey SCSI driver, or a possible

Re: [HACKERS] Write cache

2004-01-28 Thread ohp
Hi Simon, Sorry I couldn't answer sooner. Hope your daughter is OK by now. On Wed, 28 Jan 2004, Simon Riggs wrote: > Date: Wed, 28 Jan 2004 14:56:40 - > From: Simon Riggs <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], 'pgsql-hackers list' <[EMAIL PROTECTED

Re: [HACKERS] Write cache

2004-01-27 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: > This would be the first time a SCSI disk lies about its write caching. > There are plenty of low-cost (i.e. IDE) disks out there having a hidden > write cache, but AFAIK a generic SCSI tool is usable to enable/disable > the write cache. A SCSI disk sh

Re: [HACKERS] Write cache

2004-01-27 Thread Andreas Pflug
[EMAIL PROTECTED] wrote: Nothing special... And any option I could use would'nt change a thing: the cache is on the disk itself... I did'nt look physicaly yet but according to the docs there's no way to disable it lik I always did on IBM... I was forced to buy those disk (more expensive, not bett

Re: [HACKERS] Write cache

2004-01-27 Thread Larry Rosenman
--On Tuesday, January 27, 2004 23:03:56 +0100 [EMAIL PROTECTED] wrote: On Tue, 27 Jan 2004, Larry Rosenman wrote: Date: Tue, 27 Jan 2004 16:02:40 -0600 From: Larry Rosenman <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: pgsql-hackers list <[EMAIL PROTECTED]> Subject: Re: Write cache --On Tuesd

Re: [HACKERS] Write cache

2004-01-27 Thread ohp
On Tue, 27 Jan 2004, Larry Rosenman wrote: > Date: Tue, 27 Jan 2004 16:02:40 -0600 > From: Larry Rosenman <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: Write cache > > > > --On Tuesday, January 27, 2004 23:01:45 +0100 [EMAIL PROTECTED] wrot

Re: [HACKERS] Write cache

2004-01-27 Thread Larry Rosenman
--On Tuesday, January 27, 2004 23:01:45 +0100 [EMAIL PROTECTED] wrote: On Tue, 27 Jan 2004, Larry Rosenman wrote: Date: Tue, 27 Jan 2004 15:55:49 -0600 From: Larry Rosenman <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: pgsql-hackers list <[EMAIL PROTECTED]> Subject: Re: Write cache --On Tuesd

Re: [HACKERS] Write cache

2004-01-27 Thread ohp
On Tue, 27 Jan 2004, Larry Rosenman wrote: > Date: Tue, 27 Jan 2004 15:55:49 -0600 > From: Larry Rosenman <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: Write cache > > > > --On Tuesday, January 27, 2004 22:48:42 +0100 [EMAIL PROTECTED] wrot

Re: [HACKERS] Write cache

2004-01-27 Thread Larry Rosenman
--On Tuesday, January 27, 2004 22:48:42 +0100 [EMAIL PROTECTED] wrote: On Tue, 27 Jan 2004, Larry Rosenman wrote: Date: Tue, 27 Jan 2004 15:45:20 -0600 From: Larry Rosenman <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Cc: pgsql-hackers list <[EMAIL PROTECTED]> Subject: Re: Write cache --On Tuesd

Re: [HACKERS] Write cache

2004-01-27 Thread ohp
On Tue, 27 Jan 2004, Larry Rosenman wrote: > Date: Tue, 27 Jan 2004 15:45:20 -0600 > From: Larry Rosenman <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Cc: pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: Write cache > > > > --On Tuesday, January 27, 2004 22:43:34 +0100 [EMAIL PROTECTED] wrot

Re: [HACKERS] Write cache

2004-01-27 Thread Larry Rosenman
--On Tuesday, January 27, 2004 22:43:34 +0100 [EMAIL PROTECTED] wrote: On Tue, 27 Jan 2004, Larry Rosenman wrote: Date: Tue, 27 Jan 2004 15:38:30 -0600 From: Larry Rosenman <[EMAIL PROTECTED]> To: [EMAIL PROTECTED], pgsql-hackers list <[EMAIL PROTECTED]> Subject: Re: Write cache IDE or SCSI? SC

Re: [HACKERS] Write cache

2004-01-27 Thread ohp
On Tue, 27 Jan 2004, Larry Rosenman wrote: > Date: Tue, 27 Jan 2004 15:38:30 -0600 > From: Larry Rosenman <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], pgsql-hackers list <[EMAIL PROTECTED]> > Subject: Re: Write cache > > IDE or SCSI? SCSI > > Why do you think the WC is screwing you? > Because afte

Re: [HACKERS] Write cache

2004-01-27 Thread Larry Rosenman
IDE or SCSI? Why do you think the WC is screwing you? Which driver(s)? LER --On Tuesday, January 27, 2004 22:34:46 +0100 [EMAIL PROTECTED] wrote: Because I've lost a lot of data using postgresql (and I know for sure this should'nt happen) I've gone a bit further reading documentations on my di

[HACKERS] Write cache

2004-01-27 Thread ohp
Because I've lost a lot of data using postgresql (and I know for sure this should'nt happen) I've gone a bit further reading documentations on my disks and... I have FUJITSU MAP3367NC 36G 1 rpm disks, those disk have a write cache of 8Mb, if someone could tell me hox to turn it off... Could'nt