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

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 no

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

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 e

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.

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

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

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 hi

[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