Re: Performance features the 4th - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: Performance features the 4th
Date
Msg-id 3FAEC4E9.9010707@bigfoot.com
Whole thread Raw
In response to Re: Performance features the 4th  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:

> Jan Wieck <JanWieck@Yahoo.com> writes:
> 
>>However, I have not seen much evidence yet that the vacuum delay alone 
>>does that much.
> 
> 
> Gaetano and a couple of other people did experiments that seemed to show
> it was useful.  I think we'd want to change the shape of the knob per
> later suggestions (sleep 10 ms every N blocks, instead of N ms every
> block) but it did seem that there was useful bang for little buck there.

Right, I'd like to try know the patch:  "sleep N ms every M blocks".
Can you please post this patch ?

BTW, I'll see if I'm able to apply it also to a 7.3.X ( our production
DB).

Regards
Gaetano Mendola



pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: OSR5: Passes without the setsockopt() calls...
Next
From: Jan Wieck
Date:
Subject: Re: Performance features the 4th