Time to up bgwriter_lru_maxpages?

From: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>
To: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Time to up bgwriter_lru_maxpages?
Date: 2016-11-28 19:40:53
Message-ID: f6e58a22-030b-eb8a-5457-f62fb08d701c@BlueTreble.com
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-hackers

With current limits, the most bgwriter can do (with 8k pages) is 1000
pages * 100 times/sec = 780MB/s. It's not hard to exceed that with
modern hardware. Should we increase the limit on bgwriter_lru_maxpages?
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)


Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-11-28 19:48:10 Re: Wrong order of tests in findDependentObjects()
Previous Message Jonathon Nelson 2016-11-28 19:39:28 Bug in Physical Replication Slots (at least 9.5)?