Re: autovacuum launcher eating too much CPU

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Darcy Buskermolen <darcyb(at)commandprompt(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: autovacuum launcher eating too much CPU
Date: 2007-09-14 01:10:00
Message-ID: 20070914011000.GD8738@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 2GB+ AVL..

Huh, sorry for not letting you know, I already fixed that :-) (Please
grab the latest CVS HEAD and confirm.)

--
Alvaro Herrera http://www.advogato.org/person/alvherre
"Entristecido, Wutra (canción de Las Barreras)
echa a Freyr a rodar
y a nosotros al mar"

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-09-14 03:16:42 Re: Reducing Transaction Start/End Contention
Previous Message Jan Wieck 2007-09-14 00:55:00 Re: terms for database replication: synchronous vs eager