| 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: | Whole Thread | Raw Message | 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 |