Re: Write cache

Поиск
Список
Период
Сортировка
От Larry Rosenman
Тема Re: Write cache
Дата
Msg-id 370800000.1075240549@lerlaptop-red.iadfw.net
обсуждение исходный текст
Ответ на Re: Write cache  (ohp@pyrenet.fr)
Ответы Re: Write cache  (ohp@pyrenet.fr)
Список pgsql-hackers

--On Tuesday, January 27, 2004 22:48:42 +0100 ohp@pyrenet.fr wrote:

> On Tue, 27 Jan 2004, Larry Rosenman wrote:
>
>> Date: Tue, 27 Jan 2004 15:45:20 -0600
>> From: Larry Rosenman <ler@lerctr.org>
>> To: ohp@pyrenet.fr
>> Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
>> Subject: Re: Write cache
>>
>>
>>
>> --On Tuesday, January 27, 2004 22:43:34 +0100 ohp@pyrenet.fr wrote:
>>
>> > On Tue, 27 Jan 2004, Larry Rosenman wrote:
>> >
>> >> Date: Tue, 27 Jan 2004 15:38:30 -0600
>> >> From: Larry Rosenman <ler@lerctr.org>
>> >> To: ohp@pyrenet.fr, pgsql-hackers list <pgsql-hackers@postgresql.org>
>> >> Subject: Re: Write cache
>> >>
>> >> IDE or SCSI?
>> > SCSI
>> >>
>> >> Why do you think the WC is screwing you?
>> >>
>> > Because after a sys crash, the most used filesystems (databases) are
>> > screwed
>> what VxFS mount options are you using?
> 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 better)
define not special?

ISTM that the driver should force it out to the disk, unless the disk is
lying to the driver, or the driver is buggy.


>  >
>>
>> >> Which driver(s)?
>> >>
>> > Guess... ADPU320
>> Hrm.
>>
>> >> LER
>> >>
>> >>
>> >> --On Tuesday, January 27, 2004 22:34:46 +0100 ohp@pyrenet.fr 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 disks and...
>> >> >
>> >> > I have FUJITSU MAP3367NC 36G 10000 rpm disks, those disk have a
>> >> > write cache of 8Mb, if someone could tell me hox to turn it off...
>> >> > Could'nt find it in the docs and this could very well explain why a
>> >> > busy database crashes every time
>> >> >
>> >> > Thanks for your help
>> >> >
>> >> > --
>> >> > Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
>> >> > 6, Chemin d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
>> >> > 31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
>> >> > FRANCE                          Email: ohp@pyrenet.fr
>> >> > -------------------------------------------------------------------
>> >> > --- --- ----- Make your life a dream, make your dream a reality. (St
>> >> > Exupery)
>> >>
>> >>
>> >>
>> >>
>> >
>> > --
>> > Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
>> > 6, Chemin d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
>> > 31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
>> > FRANCE                          Email: ohp@pyrenet.fr
>> > ----------------------------------------------------------------------
>> > --- ----- Make your life a dream, make your dream a reality. (St
>> > Exupery)
>>
>>
>>
>>
>
> --
> Olivier PRENANT                    Tel: +33-5-61-50-97-00 (Work)
> 6, Chemin d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
> 31190 AUTERIVE                       +33-6-07-63-80-64 (GSM)
> FRANCE                          Email: ohp@pyrenet.fr
> -------------------------------------------------------------------------
> ----- Make your life a dream, make your dream a reality. (St Exupery)



--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Function call
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Another optimizer question