Re: 500 tpsQL + WAL log implementation

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: 500 tpsQL + WAL log implementation
Дата
Msg-id 3ED259AC.4070704@Yahoo.com
обсуждение исходный текст
Ответ на Re: 500 tpsQL + WAL log implementation  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: 500 tpsQL + WAL log implementation  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian wrote:
> [...]
> If we could somehow know the platter location, or tell the disk drive to
> write it in several locations, whichever is closest, I think we would
> have a real win.  However, I don't see any way of doing that.
> 
> Imagine what we could do with 8mb of battery-backed RAM!  This is sort
> of what we are using WAL/disk for, and it really isn't very good at it.

Isn't that what modern disk drives have ... well, not exactly battery 
backed, but actually the energy they have in the rotation is enough to 
flush the "write cache" out to the surface and get the heads back into 
the parking position in the case of a power loss.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bug(s) or not?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: 500 tpsQL + WAL log implementation