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.