Thread: Vacuum Delay feature

The attached patch applies to CVS tip as of 02/05/2004 and implements
the cost based vacuum delay feature.

A detailed description with charts of different configuration settings
can be found here:

     http://developer.postgresql.org/~wieck/vacuum_cost/

There is a problem left that seems to be related to Toms observations in
the shutdown behaviour of the postmaster. My current guess is that the
napping done via select(2) somehow prevents responding to the query
abort signal.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

Attached is a corrected version that solves the query cancel problem by
not napping any more and going full speed as soon as any signal is
pending. If nobody objects, I'm going to commit this tomorrow.


Jan


Jan Wieck wrote:

> The attached patch applies to CVS tip as of 02/05/2004 and implements
> the cost based vacuum delay feature.
>
> A detailed description with charts of different configuration settings
> can be found here:
>
>      http://developer.postgresql.org/~wieck/vacuum_cost/
>
> There is a problem left that seems to be related to Toms observations in
> the shutdown behaviour of the postmaster. My current guess is that the
> napping done via select(2) somehow prevents responding to the query
> abort signal.
>
>
> Jan
>


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #

Jan Wieck wrote:
> Attached is a corrected version that solves the query cancel problem by
> not napping any more and going full speed as soon as any signal is
> pending. If nobody objects, I'm going to commit this tomorrow.

Jan, three questions.  First, is this useful now that we have the new
cache replacement code, second, do we need this many parameters (can't
any of them be autotuned), and third, what about documentation?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073