Horton

Re: Time to up bgwriter_lru_maxpages?

Joshua D. Drake <jd@commandprompt.com>

View thread View on postgr.es
From: "Joshua D. Drake" <jd@commandprompt.com>
To: Jim Nasby <Jim.Nasby@BlueTreble.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2016-11-28T19:53:41Z
Lists: 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.

Commits

  1. Increase upper bound for bgwriter_lru_maxpages.