Re: Time to up bgwriter_lru_maxpages? - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Time to up bgwriter_lru_maxpages?
Date
Msg-id eee1e654-7cae-d189-cc9f-7f9e85e34f66@BlueTreble.com
Whole thread Raw
In response to Re: Time to up bgwriter_lru_maxpages?  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Time to up bgwriter_lru_maxpages?
Re: Time to up bgwriter_lru_maxpages?
List pgsql-hackers
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)



pgsql-hackers by date:

Previous
From: Petr Jelinek
Date:
Subject: Re: Logical Replication WIP
Next
From: "David G. Johnston"
Date:
Subject: Re: PSQL commands: \quit_if, \quit_unless