Re: autovacuum launcher eating too much CPU

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: autovacuum launcher eating too much CPU
Дата
Msg-id 20070924164006.GC6353@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: autovacuum launcher eating too much CPU  (Darcy Buskermolen <darcyb@commandprompt.com>)
Список 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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Darcy Buskermolen
Дата:
Сообщение: Re: autovacuum launcher eating too much CPU
Следующее
От: Tom Lane
Дата:
Сообщение: Re: GUC variable renaming, redux