Re: Experimental ARC implementation - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: Experimental ARC implementation
Date
Msg-id 3FA929CB.7000406@Yahoo.com
Whole thread Raw
In response to Re: Experimental ARC implementation  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
List pgsql-hackers
Zeugswetter Andreas SB SD wrote:

>> My plan is to create another background process very similar to 
>> the checkpointer and to let that run forever basically looping over that 
>> BufferSync() with a bool telling that it's the bg_writer.
> 
> Why not use the checkpointer itself inbetween checkpoints ?
> use a min and a max dirty setting like Informix. Start writing
> when more than max are dirty stop when at min. This avoids writing
> single pages (which is slow, since it cannot be grouped together
> by the OS).

Current approach is similar ... if I strech the IO and syncing over the 
entire 150-300 second checkpoint interval, grouping in 50 pages then 
sync()+nap, the system purr's pretty nice and without any peaks.


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: "Anand, VJ (MED, GEMS-IT)"
Date:
Subject: BTree information
Next
From: Greg Stark
Date:
Subject: Re: Open Sourcing pgManage