Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-24 Thread Darcy Buskermolen
On September 23, 2007 09:12 pm, Alvaro Herrera wrote: Darcy Buskermolen wrote: On September 14, 2007 06:36 am, Alvaro Herrera wrote: Darcy, please also apply the following patch and see if it reduces the CPU consumption to a reasonable level. This is looking much better now too, it's

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-24 Thread Alvaro Herrera
Darcy Buskermolen wrote: On September 23, 2007 09:12 pm, Alvaro Herrera wrote: Darcy Buskermolen wrote: On September 14, 2007 06:36 am, Alvaro Herrera wrote: Darcy, please also apply the following patch and see if it reduces the CPU consumption to a reasonable level. This is

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-23 Thread Alvaro Herrera
Darcy Buskermolen wrote: On September 14, 2007 06:36 am, Alvaro Herrera wrote: Darcy, please also apply the following patch and see if it reduces the CPU consumption to a reasonable level. This is looking much better now too, it's brought the AVL down to near 0% CPU usage. Thanks,

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-14 Thread Alvaro Herrera
Alvaro Herrera wrote: Darcy Buskermolen wrote: On Thursday 13 September 2007 09:16:52 Alvaro Herrera wrote: Hi, Darcy Buskermolen noticed that when one has many databases, the autovac launcher starts eating too much CPU. Don't forget the memory leak as well. after 3 or 4 days

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-14 Thread Darcy Buskermolen
On September 14, 2007 06:36 am, Alvaro Herrera wrote: Alvaro Herrera wrote: Darcy Buskermolen wrote: On Thursday 13 September 2007 09:16:52 Alvaro Herrera wrote: Hi, Darcy Buskermolen noticed that when one has many databases, the autovac launcher starts eating too much CPU.

[HACKERS] autovacuum launcher eating too much CPU

2007-09-13 Thread Alvaro Herrera
Hi, Darcy Buskermolen noticed that when one has many databases, the autovac launcher starts eating too much CPU. I tried it here with 200 databases and indeed it does seem to eat its share. Even with the default naptime, which I wouldn't have thought that was too high (it does make the launcher

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-13 Thread Alvaro Herrera
Alvaro Herrera wrote: Darcy Buskermolen noticed that when one has many databases, the autovac launcher starts eating too much CPU. I tried it here with 200 databases and indeed it does seem to eat its share. Even with the default naptime, which I wouldn't have thought that was too high

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-13 Thread Darcy Buskermolen
On Thursday 13 September 2007 09:16:52 Alvaro Herrera wrote: Hi, Darcy Buskermolen noticed that when one has many databases, the autovac launcher starts eating too much CPU. Don't forget the memory leak as well. after 3 or 4 days of running I end up with a 2GB+ AVL.. I tried it here with

Re: [HACKERS] autovacuum launcher eating too much CPU

2007-09-13 Thread Alvaro Herrera
Darcy Buskermolen wrote: On Thursday 13 September 2007 09:16:52 Alvaro Herrera wrote: Hi, Darcy Buskermolen noticed that when one has many databases, the autovac launcher starts eating too much CPU. Don't forget the memory leak as well. after 3 or 4 days of running I end up with a