Re: Two Necessary Kernel Tweaks for Linux Systems

Поиск
Список
Период
Сортировка
Искать
От
Richard Neill
Тема
Re: Two Necessary Kernel Tweaks for Linux Systems
Дата
Msg-id
50E4D51A.5060304@richardneill.org
Ответ на
Список
Дерево обсуждения
Re: Two Necessary Kernel Tweaks for Linux Systems "Midge Brown" <midgems@sbcglobal.net>
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas <sthomas@optionshouse.com>
Re: Two Necessary Kernel Tweaks for Linux Systems Scott Marlowe <scott.marlowe@gmail.com>
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas <sthomas@optionshouse.com>
Re: Two Necessary Kernel Tweaks for Linux Systems Scott Marlowe <scott.marlowe@gmail.com>
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas <sthomas@optionshouse.com>
Re: Two Necessary Kernel Tweaks for Linux Systems AJ Weber <aweber@comcast.net>
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas <sthomas@optionshouse.com>
Re: Two Necessary Kernel Tweaks for Linux Systems Alan Hodgson <ahodgson@simkin.ca>
Re: Two Necessary Kernel Tweaks for Linux Systems Boszormenyi Zoltan <zb@cybertec.at>
Re: Two Necessary Kernel Tweaks for Linux Systems Henri Philipps <henri.philipps@gmail.com>
Re: Two Necessary Kernel Tweaks for Linux Systems Shaun Thomas <sthomas@optionshouse.com>
autovacuum fringe case? AJ Weber <aweber@comcast.net>
Re: autovacuum fringe case? Evgeniy Shishkin <itparanoia@gmail.com>
Re: autovacuum fringe case? Jeff Janes <jeff.janes@gmail.com>
Re: autovacuum fringe case? AJ Weber <aweber@comcast.net>
Re: autovacuum fringe case? Alvaro Herrera <alvherre@2ndquadrant.com>
Re: autovacuum fringe case? Jeff Janes <jeff.janes@gmail.com>
Dear Shaun,

Thanks for that - it's really interesting to know.

On 02/01/13 21:46, Shaun Thomas wrote:
> Hey everyone!
>
> After much testing and hair-pulling, we've confirmed two kernel
> settings that should always be modified in production Linux systems.
> Especially new ones with the completely fair scheduler (CFS) as
> opposed to the O(1) scheduler.

Does it apply to all types of production system, or just to certain 
workloads?

For example, what happens when there are only one or two concurrent
processes?  (i.e. there are always several more CPU cores than there are
actual connections).


> * sched_autogroup_enabled
>
> This is a relatively new patch which Linus lauded back in late 2010.
> It basically groups tasks by TTY so perceived responsiveness is
> improved. But on server systems, large daemons like PostgreSQL are
> going to be launched from the same pseudo-TTY, and be effectively
> choked out of CPU cycles in favor of less important tasks.


I've got several production servers using Postgres: I'd like to squeeze 
a bit more performance out of them, but in all cases, one (sometimes 
two) CPU cores are (sometimes) maxed out, but there are always several 
cores permanently idling. So does this apply here?

Thanks for your advice,

Richard

В списке pgsql-performance по дате отправления
От: Shaun Thomas
Дата:
От: Daniel Westermann
Дата:
FAQ