Re: [HACKERS] autovacuum does not start in HEAD

2007-05-07 Thread Alvaro Herrera
ITAGAKI Takahiro wrote: > Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > > ITAGAKI Takahiro wrote: > > > > I found that autovacuum launcher does not launch any workers in HEAD. > > > > > > The attached autovacuum-fix.patch could fix the problem. I changed > > > to use 'greater or equal' instead of

Re: [HACKERS] autovacuum does not start in HEAD

2007-05-06 Thread ITAGAKI Takahiro
Alvaro Herrera <[EMAIL PROTECTED]> wrote: > ITAGAKI Takahiro wrote: > > > I found that autovacuum launcher does not launch any workers in HEAD. > > > > The attached autovacuum-fix.patch could fix the problem. I changed > > to use 'greater or equal' instead of 'greater' at the decision of > > next

Re: [HACKERS] autovacuum does not start in HEAD

2007-05-02 Thread Alvaro Herrera
ITAGAKI Takahiro wrote: > I wrote: > > I found that autovacuum launcher does not launch any workers in HEAD. > > The attached autovacuum-fix.patch could fix the problem. I changed > to use 'greater or equal' instead of 'greater' at the decision of > next autovacuum target. I have committed a patc

Re: [HACKERS] autovacuum does not start in HEAD

2007-05-01 Thread Alvaro Herrera
ITAGAKI Takahiro wrote: > I wrote: > > I found that autovacuum launcher does not launch any workers in HEAD. > > The attached autovacuum-fix.patch could fix the problem. I changed > to use 'greater or equal' instead of 'greater' at the decision of > next autovacuum target. I developed a different

Re: [PATCHES] [HACKERS] autovacuum does not start in HEAD

2007-04-26 Thread Bruce Momjian
Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- IT

Re: [HACKERS] autovacuum does not start in HEAD

2007-04-25 Thread ITAGAKI Takahiro
I wrote: > I found that autovacuum launcher does not launch any workers in HEAD. The attached autovacuum-fix.patch could fix the problem. I changed to use 'greater or equal' instead of 'greater' at the decision of next autovacuum target. The point was in the resolution of timer; There is a platfo

Re: [HACKERS] autovacuum does not start in HEAD

2007-04-25 Thread Alvaro Herrera
ITAGAKI Takahiro wrote: > I found that autovacuum launcher does not launch any workers in HEAD. > > AFAICS, we track the time to be vaccumed of each database in the following > way: > > 1. In rebuild_database_list(), we initialize avl_dbase->adl_next_worker >with (current_time + autovacuum_n

[HACKERS] autovacuum does not start in HEAD

2007-04-25 Thread ITAGAKI Takahiro
I found that autovacuum launcher does not launch any workers in HEAD. AFAICS, we track the time to be vaccumed of each database in the following way: 1. In rebuild_database_list(), we initialize avl_dbase->adl_next_worker with (current_time + autovacuum_naptime / nDBs). 2. In do_start_worker()