Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cBRou-0004nn-3O for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Nov 2016 19:42:32 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cBRot-00038V-MW for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Nov 2016 19:42:31 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cBRnU-0001aB-3Q for pgsql-hackers@postgresql.org; Mon, 28 Nov 2016 19:41:04 +0000 Received: from mail-by2nam03on0080.outbound.protection.outlook.com ([104.47.42.80] helo=NAM03-BY2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cBRnQ-0007rC-Ib for pgsql-hackers@postgresql.org; Mon, 28 Nov 2016 19:41:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=96aXnqNCVVof6IiySaL9ww6DajBjgjWbtudyBpH0s5A=; b=lNM+oCIbMfXt5a9FPtvQJ12BeEiW9eVC9kgJpWRlDvfZK35sRkIYdkYriQvUNy5piZ/pz6Skt3pO5NA3f7lIyC5wyHrHqXLW5hVwfghfhecC987S2Bp6ebqgAPTYziz0uka4c9OB9kGlFmTRW8jdzSLWiDDIdIlvCBUj2nYep0o= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.local (206.169.134.11) by DM5PR11MB1641.namprd11.prod.outlook.com (10.172.38.12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.747.13; Mon, 28 Nov 2016 19:40:57 +0000 To: Pg Hackers From: Jim Nasby Subject: Time to up bgwriter_lru_maxpages? Message-ID: Date: Mon, 28 Nov 2016 11:40:53 -0800 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.5.0 MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [206.169.134.11] X-ClientProxiedBy: CO2PR11CA0016.namprd11.prod.outlook.com (10.141.242.154) To DM5PR11MB1641.namprd11.prod.outlook.com (10.172.38.12) X-MS-Office365-Filtering-Correlation-Id: fc331805-67e6-4b18-937f-08d417c67993 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:DM5PR11MB1641; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;3:YJIxTaKI+sQU44PHMR+w7PdAJYdap2ltZzdjp1CKErA3UVqbm9UuFPKY4w/Rqck62Wh2D/eIIJKMTcYqCZMkaqMMkXFxA/ylKcY5BGmnfeNzyRP/MsM2xSXu9GCd6TbuN5MWH9+iM83hYE1nNRBQXVd4cxe9oy8rG99fRziqDwTP+CEe9d8t4aHfGA9thvcIiG4VCk3RLkcP5Aj3QZNqGajeAFkqkgEbbzTwLsoFqo3C5kQXjaursY4SzfuVYoyElfXKJFfQP8zubWk5xbR07A== X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;25:94NehiADfYXv3rtaXSUqMOSkut3nkf/o3B+/D3IdcaMAi/qb1diHt2gQ/kAuSLPZ5HsxjywmIwxk7y/Y//y5hmiuoPxy6ZyQKvZtqlkecLqaCP3blNpTssk1SRB3zeOkR+j4LzMGKTyNUWbnpRRtYoISnas/dC3MuZ+CsuQPjpQ6in5qBAzvCXOTzGVun3IYfLhxOYJCtgX6ZVHA3KCwVYW0zjvxfeKTz++JLmQIILBGfMi+8rZSO/FQtE5kN1KqXSbvN82ffcYvHEbVZwyI6QF9ywWV8JsvPtXt/LcxvJ1/JcKMEk8isVrdMWBSwOApmvmLt21M0VpJOh7EHFxoZhvZQTA2pXsjy/jnblL3CAgHIlN64MXcrBB3NRQogg7rzIr4h5M1x7NCUdfOqvkzmjZdk27wURwBUxD1Eyvl3TtlUBmGn+XihXKmrXonOFYMdN0Gg4o/1WKi6mJ0iDqAo5Qr+g8XziYOtOxBAVKxhQRZmP7aeEif9v4HJXiiis/jiQf5bIZ0uRzc/2BWae33yZOPt3Sp+2tiu/9FOC9xRoGnuY8NBQNyCeRUSWjcE3pyEzYNM33k6OmBTYUCze7NvF6GqJ2JCP6jaCTb9Vb7JZD0R2XnUGp/aH0M/BKG2xFysuvVHTSNxxOqjiCtJJlszezSG+OqlcG9TXUxIMx0LOiiQboP6CIoK2++VAm6ixsLTIzmxPbJyUBu8yNUP/pgP/llg8kxNCki1KOCWgFm5rD21gmprRbkLT582KlOG/nJnLqpHhOARE5pKOBLw2EqCjT6Y/+AN52+CNFhIc1YeI7vFhXThCmNaMT+A560/lIa8eWT0aLcClYeENjnO63SWlIejEU5VbgvR/3tjGjgm0M= X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;31:OSsWruTkpVAjljQa9CnJJc+/FwUcrgtXSm7SNV/JGMAqGUkVczxJXfvnSB0A1BFYmFIjSDhTG9OHi0ACEqDApvCQf9+++GRNynlfSqgWJwU56p4KLvSeM377H/oiIazeOxTn95HcPaxKGLf9MAF9HMTuSpP/9BXcX6komcsr9nlgghubIDkyls4ER1v1vEkkeWzC+XPWxyaLWxQmUFT9B67ac/6nty15HE1WMbckjEpWsvaXkEytrx1MK86kmzUTz/Yr4PNO2fSrQowBuT0v6oGc/tSzO3lagbrOV3wPpAs= X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6045199)(6040361)(6060326)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6061324)(6041248)(20161123555025)(20161123564025)(20161123560025)(2016111802025)(20161123562025)(6043046);SRVR:DM5PR11MB1641;BCL:0;PCL:0;RULEID:;SRVR:DM5PR11MB1641; X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;4:2nc8uSZYGsdFpYInWZer8fN+vV1ytMxkdTM3m5h+uSqn1qrIOSKthhq4Kt3OrAoTrrucFGeW8hTt3jD51fEPwNL5WOXRnrTfE1zm2uU8efIfs7jBXdgjEWSTnVzmwhObyWJMON/s/fyxr+sIdmnx0U5IgLRmEG0z0D/KOCtD+Gp/2HSFNhMnQ940nWb+Xl6KjrRtDmWXDmvBgVTZhWJIVDrwrQOKqqz5vmz6iM60GNzNPkJLBi1XZExhnaqW5tYtYGpoqT9qK1nyldQ7GPvqoPgk5TbEZAbMbCSurvUuAaZtAp1JBF3+ThNFa/c/UNwK1t4hNYoTmcO3uQnaLQ+YS47Q2hVEr9y+l5duh+pUMYaDonjaCBuv5fFycqXwfD+JSSuZob+OYuAbFMJWm696LLUJlxGYuBKXtbxpboaDpuAVM3z473PYZ1beTAdXCDrwwljFvXvAlbHEEWYbSARjBf6mwFFDRquEzCQAx4JBVl0eOSCwIG055Yr2Uv5C6wp1bOeKlVr2UvXB2EdSkp8JjjMtyjuVZKc86CVzwmbsgPPkdOpzyWzguleWEY9pX5R39ZziSm3j//mvtvpbC6yssfFw3DTdMM0FeZTUqW1IfqJ9F8XikDexraFygXDXtSNmOIeYNAbTZ+USlYUtElZexa5/Itb7vaMVWBNm84zoopA= X-Forefront-PRVS: 01401330D1 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(199003)(189002)(50986999)(86362001)(54356999)(64126003)(230700001)(106356001)(7736002)(305945005)(105586002)(38730400001)(101416001)(65956001)(7846002)(50466002)(6916009)(31686004)(110136003)(42186005)(33646002)(31696002)(65806001)(6666003)(66066001)(47776003)(5660300001)(8676002)(68736007)(23676002)(450100001)(39400400001)(39410400001)(2906002)(39380400001)(92566002)(81166006)(81156014)(733004)(39450400002)(6486002)(65826007)(36756003)(6116002)(3846002)(107886002)(4001350100001)(97736004)(16601075003)(83506001)(189998001)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:DM5PR11MB1641;H:decina.local;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtETTVQUjExTUIxNjQxOzIzOlhxczRjbjJpUUJxNHVad3FzYUdxWW5ybElD?= =?utf-8?B?QTMxYzRNb1lOWmY5V2E5dWsvM1NDbVBRdXk3bVhqUDkrRWNhMTFkQkZFb2pl?= =?utf-8?B?Uk1mc0M1alpLZDArck5tYWZhTzlVREdERDZvcVo3d1VycjJPQlhrcDI3MWow?= =?utf-8?B?K2I2VWZqb3craTk2YUw5cHlQU2c3VHJELzJEQWRqaHJWeFFaVjBaa0xNOW5s?= =?utf-8?B?SG80dXRtcjJWN24rNmg5SkZZVEE1UjR5Ymp2djZuNFZvbHNLRkR5QnNWNzdG?= =?utf-8?B?YkNTZTF4aGtLYzhIYllSZXljWm1XSzRaNUVGMWppc2xwYWZyK1N2SklhQVdM?= =?utf-8?B?Q2NXWFF0S1RHT01WVFBrMjg0Z0krQW9nTFFpelV1Q3M4U2NFZ3BFSktjeWd4?= =?utf-8?B?NEk2U0hjVkVYb25RN043VUx0SWFJTUdxaHVEbHNTWEJJR1BEbXZBYlBVSldy?= =?utf-8?B?VVZ3YVlrTWlSQ3VqejRmNkVTUUt1TVY5NlN6MkVmdjBMTTVPL2pualMyYmpV?= =?utf-8?B?VWtuM216aXJGSXNyYWl1T1Yva1dPMHVjM0RneGEwVnRRa29aK1FxaWtGcjd3?= =?utf-8?B?bmFCM3Z3L0hneFp1ajhuK010Kyt5MGZ0b05QaHdkRG9aSUlwc2VuSmo4OC9S?= =?utf-8?B?TmN3akZ0eU1ZREtpbytyR1VYa0FIYVBNU2wza2oxRzBDdTJPSHFQQTdtU2gx?= =?utf-8?B?OTMrMWNLdkpFM0JBc0x6b0Y1TUl5TWpaeklWR3l3cUxEQ2ZiWWZDanhWS1lU?= =?utf-8?B?NklXU3l5WS9WQ0RoT2pIUmVxYis1WU5xZFR5aFhKTVpDKy9kM1BtZkcwR0NH?= =?utf-8?B?aDQzc2VYclpXOERtYkNjQjhEKzM3c2U3YWxwNzBpNVFKbWJEUjlJUzhYcjRY?= =?utf-8?B?OVNCZTZvWmw3TCtLWXNGRi9vYWZpZWdobHUrU3oxamJCNEpPZVEyZEdtd0Qy?= =?utf-8?B?bDEzTnMwaHN2NjRtN2VZYnExWmJWOEdaN3ZvQlBwMXhYOFVjWE5waHFLL05q?= =?utf-8?B?TTRLcGxGSHUrWC8rcEZaTUV4enpuOFZCYTJJTEhLaU1PR3o0eHltQU51ZDhE?= =?utf-8?B?bFd6cWtqV1A5VmNsZXhsK0hWcE01RnZYM3RTUEdmWU9VYm55VEdvYWd6ai9E?= =?utf-8?B?ZFFTU0cyczl5R1lZTEIrdERicXF0T2VNUEtiNE1WQnQvUWg5bGV2dm1RM2lC?= =?utf-8?B?eG9FeWxBT3ExeG1nSERwWW5DSDh5ZWpBUHRQTGlMM0JuelBOVkk3dVhVdWta?= =?utf-8?B?YUw3YWR5SzFhZStGWlplMGk3aWRiRjM5aEd2WnBVNWtnMnVMclhYcEwzSlM5?= =?utf-8?B?YlFvNXZkWlZ5UWtqSEdyc3IrWk1HcU9UWWx6YUFGOE9lMnBlTWdtdzNUcEFR?= =?utf-8?B?OGl2WDljYjJ3TGVwdVI2a0QzTElVVFB0L3o1bWJ6dEt6QWVuQk9XUURLbkhu?= =?utf-8?B?NmVZbVFlMHhndHJicWtYdWpNUDg0Ri9uVFcxZmJxR2hsdUpOckpuNklvdmZM?= =?utf-8?B?bUJmUk9aeVJjc25wZWx0V0JaWjQ2VGxWK0toOHFoSUtidWdkREU2Uk5EOE5q?= =?utf-8?B?Um9yaFY2aDZBbHZSdlVKOG5qaXdjVWJQRW5KVzJWMjZTM1dUejhaN29mY1Zo?= =?utf-8?B?dkRCeStSM3hFL3pTVlROVFRCalFmUlJLTWhVUWZ3YldIMmxUVUErV1k3N1RO?= =?utf-8?B?MFUvSTBDWTJIcUdSZTN4UzBYNzM2bVdiL3FZQWZtRG1kd2hKTmVQRkpFZ1JC?= =?utf-8?B?c3FPRWEva2RjWkFyNjFnSEt1ZmcrMDNRb3JTNFJUUENsR080VmhrbUpqN1hU?= =?utf-8?Q?/WodvWxtctaXV?= X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;6:oY5SbTLgLLYYeNmbdZShTaS64d6qL+0FFqDg6O8ga/wEIerqP0YFI9uF5MZwLLtDFtFyOERr8QfAP7dHrPUTpNlpayqvfgBnDSW+fPZxyxOu1sjUHVT0KaEMKVL/TXhymk55prq9GvimAb4ALQlEL7a32/rXjKuQ9AwGaBgQk7IwpDqtK/MfEWO0mfBwxvjbpKZ/WlWnecLzyyT9E9zcol0vfvE1Sq2gb/rrURbsEBGy0qB/brh6/3s6PhtRVZbcnvFEHZtB38KEUdSpQlqu6YqGHgmtID+jmF36MstdEYFzn5Pqx0plQc8xZqTo6vN3Vhu7netVyWRv1Ns7Ditu+t3g60vqYdnZ7na4ypSxvLpKFukDmjIm0Yy87GfPwZzxKAfieVPRAGEW70LavozDerpHvkrRPg9zffTpNUTbdp3WTRRNDkPIFO5pcZ6k8pC1vl2hIBMeboQaTiGQ6HpH0lQfhWJHRA8qz0kjdxSEjTA=;5:e0uRLe71QKL2TI2x77OP/bvFCbzI04rfrf4QJbhtkBUHZFa7lSuODtY0XpnNWhIQFUtTU6tcstTFwRHVUH/S6J1SfOg//Dv6jp9hkCv+NDhJ2RhX9IL8UOD6PnWmR37xDnj0w9Niqs80Hi061m7aiA==;24:S+rm6wY6gwUa8jBTrSAScoju4kD1Em3szI3GT0Pn+AoamX8Mf5NhnkovHTlHZFv43SZA1zNVoyL2DGy/w36LXbqzCQyhxZveMEBsXag0h9Y= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;DM5PR11MB1641;7:VQIKLvCRm16oyaQHapFEWhP0yawK1rGee72EztdYnZHjXjWOM9PPPSuxaOk0vkvU44M7Xc12TgkA4elrK6PQeJs8Vh1TdCBJ+UsJqNlT2o9zAG4vX/AmzRoiq8JIpIZtClNnmdpB6x7tRUY1k6nBhPsmCKv2Byd+XscND1YjzQXN7MC6eLlzZ0qBaZZtXP1Zcm4iZ0pS+l9Hsk3Z6kyDT0/2AOlvfWXIoY8cUfSZguuy9dP+eJHhoVm1CyFylqnUtyn2Bw1UYqm2vm8oW62oMyxAghV2AXPrdvW+YnDLItr9aALPzNG+nhWjBtmPMmPFw2sgHe4/Evpjfaq7+CBTKuTrtAy74qlSW6HV9Yd5N/MirbhvuNVSWYWzNegeqPIyOG8rL5T37miqDSqQVso+91MBGzUX6196KssOCPL7v+lLQVW6kkVd3iO6tbdckewQjchA1fAELOpV/tIwvdtLow== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 28 Nov 2016 19:40:57.4799 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR11MB1641 X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org 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? -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers