* Mike Galbraith <[email protected]> wrote:
> > Just to confirm, if you turn off all preemption via a hack
> > (basically if you turn SCHED_OTHER into SCHED_BATCH), does
> > psql perform and scale much better, with the quality of
> > sibling selection and spreading of processes only being a
> > secondary effect?
>
> That has always been the case here. Preemption dominates.
Yes, so we get the best psql performance if we allow the central
proxy process to dominate a single CPU (IIRC it can easily go up
to 100% CPU utilization on that CPU - it is what determines max
psql throughput), and not let any worker run there much, right?
> Others should play with it too, and let their boxen speak.
Do you have an easy-to-apply hack patch by chance that has the
effect of turning off all such preemption, which people could
try?
Thanks,
Ingo
--
To unsubscribe from this list: send the line "unsubscribe linux-kernel" in
the body of a message to [email protected]
More majordomo info at http://vger.kernel.org/majordomo-info.html
Please read the FAQ at http://www.tux.org/lkml/
