Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3326: Invalid lower bound of autovacuum_cost_limit - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #3326: Invalid lower bound of autovacuum_cost_limit
Date
Msg-id 20070608150050.GH9071@alvh.no-ip.org
Whole thread Raw
In response to BUG #3326: Invalid lower bound of autovacuum_cost_limit  ("Galy Lee" <lee.galy@oss.ntt.co.jp>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3376: Erro : COMMIT
Next
From: "Kevin Neufeld"
Date:
Subject: BUG #3377: pg_dump: No matching tables were found