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

Re: 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: Re: Vacuum Delay feature
Date: 2004-02-05 19:18:18
Message-ID: 402296FA.7020709@Yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
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(at)Yahoo(dot)com #

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

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-02-05 19:44:43
Subject: Re: PITR Dead horse?
Previous:From: Tom LaneDate: 2004-02-05 19:05:46
Subject: It's past time to redo the smgr API

pgsql-patches by date

Next:From: Oleg LebedevDate: 2004-02-05 19:34:24
Subject: Re: dblink: rollback transaction
Previous:From: Joe ConwayDate: 2004-02-05 18:57:11
Subject: Re: dblink - custom datatypes don't work

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