Re: Time to up bgwriter_lru_maxpages?

From: Devrim Gündüz <devrim(at)gunduz(dot)org>
To: Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Time to up bgwriter_lru_maxpages?
Date: 2016-11-28 19:53:22
Message-ID: 1480362802.20040.3.camel@gunduz.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


Hi,

On Mon, 2016-11-28 at 11:40 -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?

+1 for that. I've seen many cases that we need more than 1000.

Regards,
--
Devrim Gündüz
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2016-11-28 19:53:41 Re: Time to up bgwriter_lru_maxpages?
Previous Message Tom Lane 2016-11-28 19:48:10 Re: Wrong order of tests in findDependentObjects()