Re: Postgres performance and the Linux scheduler - Mailing list pgsql-general

From Greg Smith
Subject Re: Postgres performance and the Linux scheduler
Date
Msg-id 4DFA4BE7.4060308@2ndQuadrant.com
Whole thread Raw
In response to Postgres performance and the Linux scheduler  ("Simon Windsor" <simon.windsor@cornfield.me.uk>)
List pgsql-general
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@2ndQuadrant.com   Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support  www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Postgres 8.3.10 Alter Table Waiting issue
Next
From: hernan gonzalez
Date:
Subject: Domains as typedefs: Performance and automatic casting