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-24 16:40:06
Message-ID: 20070924164006.GC6353@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 looking much better now too, it's brought the AVL down to near 0%
> > > CPU usage.
> >
> > Thanks, applied. I still feel CPU usage is somewhat excessive but I
> > don't think there's much to be done about it. Maybe I'm just testing
> > with too many databases.
>
> My findings were against 83 DB's

I was testing with 300 and naptime=10s.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-09-24 16:50:13 Re: GUC variable renaming, redux
Previous Message Tom Lane 2007-09-24 16:12:25 Re: Bytea as C string in pg_convert?