On 16 June 2011 19:10, Simon Windsor <simon.windsor@cornfield.me.uk> wrote:
> Can the performance of Postgres be boosted, especially on busy systems,
> using the none default DEADLINE Scheduler?
Probably, but it's a controversial area, and if you want to speed up a
busy system, it would be almost the last thing to look at. Changing
read-ahead settings would be almost the first thing to look at, as
ways of improving the performance of Postgres by tweaking the
operating system go. Increasing this parameter from the default is
often very effective at speeding up sequential scans.
--
Peter Geoghegan http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training and Services