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

From Jan Wieck
Subject Re: Performance features the 4th
Date
Msg-id 3FABF36C.4060109@Yahoo.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.

I thought it was "sleep N ms every M blocks".

Have we seen any numbers? Anything at all? Something that gives us a 
clue by what factor one has to multiply the total time a "VACUUM 
ANALYZE" takes, to get what effect in return?


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: Josh Berkus
Date:
Subject: Re: [pgsql-www] Changes to Contributor List
Next
From: Peter Eisentraut
Date:
Subject: Timestamps on schema objects