Skip site navigation (1) Skip section navigation (2)

Vacuum Delay feature

From: Jan Wieck <JanWieck(at)Yahoo(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>,PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Vacuum Delay feature
Date: 2004-02-05 14:05:53
Message-ID: 40224DC1.9060502@Yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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(at)Yahoo(dot)com #

Attachment: vacuum_cost.75devel.diff.gz
Description: application/x-gzip (3.0 KB)

Responses

pgsql-hackers by date

Next:From: Rod TaylorDate: 2004-02-05 14:12:59
Subject: Re: PITR Dead horse?
Previous:From: Bruce MomjianDate: 2004-02-05 13:48:30
Subject: Re: [PATCHES] log session end - again

pgsql-patches by date

Next:From: Andrew DunstanDate: 2004-02-05 14:34:33
Subject: Re: [PATCHES] log session end - again
Previous:From: Bruce MomjianDate: 2004-02-05 13:48:30
Subject: Re: [PATCHES] log session end - again

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group