Re: Background writer committed - Mailing list pgsql-hackers

From Shridhar Daithankar
Subject Re: Background writer committed
Date
Msg-id 3FBC6059.2070605@myrealbox.com
Whole thread Raw
In response to Background writer committed  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Background writer committed
List pgsql-hackers
Jan Wieck wrote:

> I committed the first part of the background writer process. We had a 
> consensus on attempting to avoid write() calls from regular backends, 
> but did no come to any conclusions what to do to force the kernel to 
> actually do some IO.
> 
> Consequently, this patch is a separate process launched by postmaster, 
> that periodically write()'s out "some" dirty buffers in LRU order. This 
> causes the buffers returned for replacement (when a backend needs to 
> read in a page) to be clean allways. The process does no sync(), fsync() 
> or any other calls thus far. Nothing has changed in the checkpoint logic 
> either.

Can we have some idea where to tweak sync routines for comparing results?

I mean I would like to run pgbench with same config all along and compare the 
performance difference between sync, fsync and fdatasync etc.

If we could get to run any live world data test by that, it would be great as well.
 Shridhar



pgsql-hackers by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: RPM building fun
Next
From: Shridhar Daithankar
Date:
Subject: Re: [PERFORM] More detail on settings for pgavd?