Re: Postgres performance and the Linux scheduler

On 06/16/2011 02:10 PM, Simon Windsor wrote:
>
> Can the performance of Postgres be boosted, especially on busy
> systems, using the none default DEADLINE Scheduler?
>
>

Some system reports moderate improvements in throughput, and sometimes
larger ones in worst-case latency, when switching from the default to
the deadline scheduler. Others report best performance with the noop
schedule. Changes here are not effective in a lot of cases though.

I wrote an article for the first issue of PostgreSQL Magazine that
mentions this, as the last of the most useful things you can tweak on
Linux; that's available at http://pgmag.org/

--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books