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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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 Content-Type Size
vacuum_cost.75devel.diff.gz application/x-gzip 3.0 KB

In response to

Responses

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

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