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