Re: Lost rows/data corruption?

From: "Andrew Hall" <temp02(at)bluereef(dot)com(dot)au>
To: "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com>
Cc: "Alban Hertroys" <alban(at)magproductions(dot)nl>, "Marco Colombo" <pgsql(at)esiway(dot)net>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Lost rows/data corruption?
Date: 2005-02-26 05:01:15
Message-ID: 009001c51bc0$32e50db0$5001010a@bluereef.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yes, we compile our own kernel based on the "stardardised" stable release
available at the time. Everything we need is compiled in. This is what I
mean by standard Linus approved kernel release (as opposed to an AC/MM
modified release etc.)

----- Original Message -----
From: "Keith C. Perry" <netadmin(at)vcsn(dot)com>
To: "Andrew Hall" <temp02(at)bluereef(dot)com(dot)au>
Cc: "Alban Hertroys" <alban(at)magproductions(dot)nl>; "Marco Colombo"
<pgsql(at)esiway(dot)net>; <pgsql-general(at)postgresql(dot)org>
Sent: Saturday, February 26, 2005 6:02 AM
Subject: Re: [GENERAL] Lost rows/data corruption?

> Quoting Andrew Hall <temp02(at)bluereef(dot)com(dot)au>:
>
>> > 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(at)postgresql(dot)org)
>>
>
> 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Stark 2005-02-26 05:40:50 Re: row numbering
Previous Message Rick Apichairuk 2005-02-26 02:24:13 Re: Newbie: help with FUNCTION