Re: Lost rows/data corruption?

Поиск
Список
Период
Сортировка
От Keith C. Perry
Тема Re: Lost rows/data corruption?
Дата
Msg-id 1109358141.421f763de57fe@webmail.vcsn.com
обсуждение исходный текст
Ответ на Re: Lost rows/data corruption?  ("Andrew Hall" <temp02@bluereef.com.au>)
Список pgsql-general
Quoting Andrew Hall <temp02@bluereef.com.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@postgresql.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Devrim GUNDUZ
Дата:
Сообщение: New sets of PostgreSQL RPMS are available for download
Следующее
От: Tom Lane
Дата:
Сообщение: Re: unsuscribe