Search Postgresql Archives

Re: Lost rows/data corruption?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Quoting Andrew Hall <temp02@xxxxxxxxxxxxxxx>:

> > Do you happen to have the same type disks in all these systems? That could
> 
> > point to a disk cache "problem" (f.e. the disks lying about having written
> 
> > data from the cache to disk).
> >
> > Or do you use the same disk parameters on all these machines? Have you 
> > tried using the disks w/o write caching and/or in synchronous mode 
> > (contrary to "async").
> 
> It's all pretty common stuff, quite a few customers use standard IDE 
> (various flavours of controller/disk), some now use SATA (again various 
> brands) and the rest use SCSI. The kernel we use is the standard Linus 
> approved kernel with the inbuilt drivers as part of the kernel. We don't 
> supply any non-default parameters to the disk controllers.
> 
> Thanks for your suggestion on write caching, I'll look into this, I'm also 
> tempted to try a different journalling FS too. 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
> 

I'm a little late on this thread but in regards to the SATA support.  2.4.29 in
my experience is really the first kernel that decent SATA support (i.e. much
better data throughput).  I think that would corresponse to 2.6.9 or .10 but
even before you get into all that.  I am curious to know what do you mean by
"standard Linus kernel".  Do you not compile your own kernels for the hardware
platform being used?

-- 
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
 
____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux