From: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
---|---|
To: | Zeugswetter Andreas SB SD <ZeugswetterA(at)spardat(dot)at> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Experimental ARC implementation |
Date: | 2003-11-05 16:48:11 |
Message-ID: | 3FA929CB.7000406@Yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-11-05 17:08:14 | Re: equal() perf tweak |
Previous Message | Zeugswetter Andreas SB SD | 2003-11-05 16:01:27 | Re: Experimental ARC implementation |