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

From Joshua D. Drake
Subject Re: Time to up bgwriter_lru_maxpages?
Date
Msg-id e7c29fa9-e106-2ec9-0dbe-accb6a541659@commandprompt.com
Whole thread Raw
In response to Time to up bgwriter_lru_maxpages?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Time to up bgwriter_lru_maxpages?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
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.

JD



-- 
Command Prompt, Inc.                  http://the.postgres.company/                        +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.



pgsql-hackers by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: Time to up bgwriter_lru_maxpages?
Next
From: Gilles Darold
Date:
Subject: Re: Patch to implement pg_current_logfile() function