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 |
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 |
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 |