Re: Time to up bgwriter_lru_maxpages?

On 11/28/16 11:53 AM, Joshua D. Drake wrote:
> On 11/28/2016 11:40 AM, Jim Nasby wrote:
>> 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?
>
> Considering a single SSD can do 70% of that limit, I would say yes.

Next question becomes... should there even be an upper limit?
-- 
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)