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

From Robert Haas
Subject Re: [HACKERS] Time to up bgwriter_lru_maxpages?
Date
Msg-id CA+TgmoYv0ud_1uT_kWd_S35XRPwU5SJFVQ3sJArYK5EH83XD3Q@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Time to up bgwriter_lru_maxpages?  (Andres Freund <andres@anarazel.de>)
Responses Re: [HACKERS] Time to up bgwriter_lru_maxpages?
List pgsql-hackers
On Wed, Feb 1, 2017 at 7:28 PM, Andres Freund <andres@anarazel.de> wrote:
> On 2016-11-28 11:40:53 -0800, 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?
>
> FWIW, I think working on replacing bgwriter (e.g. by working on the
> patch I send with a POC replacement) wholesale is a better approach than
> spending time increasing limits.

I'm happy to see it replaced, but increasing the limits is about three
orders of magnitude less work than replacing it, so let's not block
this on the theory that the other thing would be better.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] Time to up bgwriter_lru_maxpages?
Next
From: Andres Freund
Date:
Subject: Re: [HACKERS] Time to up bgwriter_lru_maxpages?