Re: 500 tpsQL + WAL log implementation - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: 500 tpsQL + WAL log implementation
Date
Msg-id 3ED259AC.4070704@Yahoo.com
Whole thread Raw
In response to Re: 500 tpsQL + WAL log implementation  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: 500 tpsQL + WAL log implementation  (Bruce Momjian <pgman@candle.pha.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug(s) or not?
Next
From: Bruce Momjian
Date:
Subject: Re: 500 tpsQL + WAL log implementation