Re: Write ahead logging

Поиск
Список
Период
Сортировка
От Matthias Meixner
Тема Re: Write ahead logging
Дата
Msg-id 3E55E8E0.60201@dvs1.informatik.tu-darmstadt.de
обсуждение исходный текст
Ответ на Re: Write ahead logging  ("Mario Weilguni" <mweilguni@sime.com>)
Ответы Re: Write ahead logging  (Rod Taylor <rbt@rbt.ca>)
Список pgsql-performance
Mario Weilguni wrote:
>>>So the question is: has anybody verified, that the log is written to disk
>>>before returning from commit?
>>
>>Some (or all?) IDE disks are known to lie:  they report success as
>>soon as the data have reached the drive's RAM.
>
>
> under linux, hdparm -W can turn off the write cache of IDE disk, maybe you
> should try with write-caching turned off.

Yes, that made a big difference. Latency went up to 25-95ms.

Regards,

    Matthias Meixner

--
Matthias Meixner                       meixner@informatik.tu-darmstadt.de
Technische Universität Darmstadt
Datenbanken und Verteilte Systeme              Telefon (+49) 6151 16 6232
Wilhelminenstraße 7, D-64283 Darmstadt, Germany    Fax (+49) 6151 16 6229


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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: performance issues for processing more then 150000
Следующее
От: Kevin White
Дата:
Сообщение: Really bad insert performance: what did I do wrong?