Re: BUG #3326: Invalid lower bound of autovacuum_cost_limit

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Galy Lee <lee(dot)galy(at)oss(dot)ntt(dot)co(dot)jp>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3326: Invalid lower bound of autovacuum_cost_limit
Date: 2007-06-08 15:00:50
Message-ID: 20070608150050.GH9071@alvh.no-ip.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers pgsql-patches

Galy Lee wrote:

> * Bug-2: 0-cost-limit for autovacuum worker
>
> When autovacuum_max_workers > autovacuum_vacuum_cost_limit, the above
> zero-division error also happened.

Ah, this is a problem in the balance code -- it fails to consider that
the cost limit may be end up being 0 in the integer calculations. This
patch fixes this problem.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Attachment Content-Type Size
autovac-balance-limit.patch text/x-diff 1.2 KB

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kevin Neufeld 2007-06-08 16:59:01 BUG #3377: pg_dump: No matching tables were found
Previous Message Tom Lane 2007-06-08 14:54:26 Re: [PATCHES] [BUGS] BUG #3326: Invalid lower bound of autovacuum_cost_limit

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2007-06-08 15:04:26 Re: COPYable logs status
Previous Message Zeugswetter Andreas ADI SD 2007-06-08 14:57:59 Re: Autovacuum launcher doesn't notice death of postmaster immediately

Browse pgsql-patches by date

  From Date Subject
Next Message Andrew Sullivan 2007-06-08 15:04:26 Re: COPYable logs status
Previous Message Tom Lane 2007-06-08 15:00:34 Re: Synchronized scans