From owner-freebsd-hackers@freebsd.org Tue Jun 13 06:24:41 2017 Return-Path: Delivered-To: freebsd-hackers@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id BEF47D8F7BA for ; Tue, 13 Jun 2017 06:24:41 +0000 (UTC) (envelope-from Aaron.Caza@ca.weatherford.com) Received: from NAM03-DM3-obe.outbound.protection.outlook.com (mail-dm3nam03on0068.outbound.protection.outlook.com [104.47.41.68]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (Client CN "mail.protection.outlook.com", Issuer "Microsoft IT SSL SHA2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 44E1B6F920 for ; Tue, 13 Jun 2017 06:24:40 +0000 (UTC) (envelope-from Aaron.Caza@ca.weatherford.com) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=weatherford.onmicrosoft.com; s=selector1-ca-weatherford-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=iImpU1JFa7ieZIf+U3ATfCU7JnNpz0nmS14OijDDI4c=; b=U1FBZQWW2nYlt2UjgsIcoJ3A2aaH3M7w/zc8FdwtRmh7Dcz/9vFGRMrVkQSuZMBi+64Gj8/7hSneRwYQruo+0EAtkg2DiyHYDScUSRYrFpBjOeOTOFybZwa44ZwNQPJU2uryfxzTTTYrZMTmZ3hHBkE6kzxgbtnP69jgeSZSHPg= Received: from BN6PR03CA0018.namprd03.prod.outlook.com (10.168.230.156) by BY2PR0301MB0742.namprd03.prod.outlook.com (10.160.63.20) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1157.12; Tue, 13 Jun 2017 06:24:37 +0000 Received: from BL2FFO11FD009.protection.gbl (2a01:111:f400:7c09::177) by BN6PR03CA0018.outlook.office365.com (2603:10b6:404:23::28) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1157.12 via Frontend Transport; Tue, 13 Jun 2017 06:24:36 +0000 Authentication-Results: spf=pass (sender IP is 23.103.226.20) smtp.mailfrom=ca.weatherford.com; zxy.spb.ru; dkim=none (message not signed) header.d=none;zxy.spb.ru; dmarc=bestguesspass action=none header.from=ca.weatherford.com; Received-SPF: Pass (protection.outlook.com: domain of ca.weatherford.com designates 23.103.226.20 as permitted sender) receiver=protection.outlook.com; client-ip=23.103.226.20; helo=032-smtp-out.weatherford.com; Received: from 032-smtp-out.weatherford.com (23.103.226.20) by BL2FFO11FD009.mail.protection.outlook.com (10.173.161.15) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1143.11 via Frontend Transport; Tue, 13 Jun 2017 06:24:36 +0000 Received: from DM2PR58MB013.032d.mgd.msft.net (141.251.110.81) by DM2PR58MB014.032d.mgd.msft.net (141.251.110.82) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1157.12; Tue, 13 Jun 2017 06:24:35 +0000 Received: from DM2PR58MB013.032d.mgd.msft.net ([141.251.110.81]) by DM2PR58MB013.032d.mgd.msft.net ([141.251.110.81]) with mapi id 15.01.1157.017; Tue, 13 Jun 2017 06:24:34 +0000 From: "Caza, Aaron" To: Slawa Olhovchenkov CC: "freebsd-hackers@freebsd.org" Subject: RE: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours Thread-Topic: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours Thread-Index: AdLiAalX9ncyh3crQla1B5/716RidAABhQ0AADIocOAATt+h8A== Date: Tue, 13 Jun 2017 06:24:34 +0000 Message-ID: References: <79528bf7a85a47079756dc508130360b@DM2PR58MB013.032d.mgd.msft.net> <20170610163642.GA18123@zxy.spb.ru> Accept-Language: en-CA, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [141.251.110.133] x-ms-publictraffictype: Email X-MS-TrafficTypeDiagnostic: DM2PR58MB014:|BY2PR0301MB0742: X-MS-Office365-Filtering-Correlation-Id: 3d32a4ef-644f-4d54-ea42-08d4b224dd0b Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OrganizationHeadersPreserved: DM2PR58MB014.032d.mgd.msft.net X-EOPAttributedMessage: 0 X-MS-Office365-Filtering-HT: Tenant X-Forefront-Antispam-Report: CIP:23.103.226.20; IPV:NLI; CTRY:; EFV:NLI; SFV:NSPM; SFS:(10009020)(6009001)(39400400002)(39450400003)(39840400002)(39860400002)(39850400002)(39410400002)(2980300002)(438002)(43784003)(199003)(189002)(377454003)(13464003)(24454002)(51914003)(9170700003)(305945005)(55016002)(2900100001)(6916009)(189998001)(6246003)(478600001)(47776003)(53936002)(8676002)(72206003)(356003)(42882006)(8936002)(86362001)(81166006)(66066001)(8746002)(22756006)(50986999)(54356999)(7736002)(3846002)(23726003)(102836003)(9686003)(97756001)(76176999)(24736003)(2906002)(46406003)(108616004)(5660300001)(33646002)(7696004)(53546009)(110136004)(229853002)(86146001)(4326008)(38730400002)(5890100001); DIR:OUT; SFP:1101; SCL:1; SRVR:BY2PR0301MB0742; H:032-smtp-out.weatherford.com; FPR:; SPF:Pass; MLV:sfv; A:0; MX:1; LANG:en; X-Microsoft-Exchange-Diagnostics: 1; BL2FFO11FD009; 1:Uo1FEGkKMMPy5/jCED+H3eRlmlDdKDNB6rfr4f2iwuVPdfzfIrferv4VLOVfwrOhGbJqEWb+6nAu6/47jgbe+OPhCHMg3oN1Pmifh9v1jfsmS+W6/BI/mBXXeua5zJE8/Q5KtGE1I6xQp8xTRlt09wFeHg70pwmbuJh8tulgmloO5Qa7Kmfs1VgaNSnibyK0h459hmcELIfEqvgJLWHV8uJrONznVhiZwrCoaLN/SV3YFu4EC+XK8oie0T+vv/kk75llsHZWjfieccaYlYCKv3kVuqrbwPDdMel8qE26Htc24pJ42EzU4Y4pEanovuW4t8No449K3xFsVhJe9DYT3mNtiJfqWMQAqTzTYOvnkZpzHomON7I7zyzAIZ2q97HSg+Jxf0c3GqbCUqKCB+U7K3aAudqyvfQW08ggyZQ8lGNxph4sqgS3qX6MfspUhU8ByvHehlbnpHheg88L7l8nx1z9NLatZj8qBX0r3beobLWPMNeUnhyt/6k06CCW2uN6gCmRLItnv5leUerNQjJbqw== X-CrossPremisesHeadersPromoted: BL2FFO11FD009.protection.gbl X-CrossPremisesHeadersFiltered: BL2FFO11FD009.protection.gbl X-Microsoft-Antispam: UriScan:; BCL:0; PCL:0; RULEID:(22001)(8251501002)(2017030254075)(201703131423075)(201703031133081); SRVR:BY2PR0301MB0742; X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0742; 3:OFJ5Nb+iJn8nTtC3pu3BY68GsFJinl7EQ54B3pin/xVPnJtMy4Nf4tQRl8tsjbCP641pi9Pmz4iakpsoGPTrVOPnCK3hILa7kLeS6QBnyWjCSkQShGU/TOk0lTfzCncUvavnYEk0PLQrgVKu/w8E/HlXM0amvaPB9XOgfuDf9rpSYQAadlCBp6wtZ8uDY/mKWfdQmRo/iwQpO9FtedRU7N7B2uEBGKyLmH5X9jlWbk/u4RTt0xIRVqW9uyWGS0JF9puKmKcrOCVLHniiQsv4en/Eiqq6Yi6FNONtbrVMgtkzM7kzWcdpWdPqbORQWHwW0XCK3OGCA8U1J1D4lre6ZgZynfKdTluJPit1HXep2X7fXXBFAtXofFHUTC3Qt2feNSs45/ey1OhR24F1zDVU7NWlOVO6XOXZgpnnbfTF3sk3B5BlBF23Sam2CFLb0ItG3VysGRuY7WUCf1agCWufse6xP5ZNi0i0no8wzr15Zv4= X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0742; 25:eoQbmX15lldkkjQFSSd4dsUoHK+RR8NP9kmetbcR8rrwSwVrP32y7Qkcu4aKXBSLZx1OC9b+oXSgaLToavJUEANC0ZgCGzipDPW/8FJcBILajv47/s9G3MHmEukW9DE2cZ6w5hA6fKWAokaCjLCM1dOaxSucCJlIyYqG+zPUr83nc4jpCJGDRFv7oxhUjsejQchzY9+ELhY4FJmEOhjIYnXKAxekWBAyjcY5nsR1O/+z1n60BPab477S0mem6ocv3ouBKfpZW84WpWikDuERujEyyKs18oRim/qZUU/EdsFw48MIkd143azTXhYmgxkl+elgeD1KDjxD/LC0PYkkjZEKmq91HHg3KrRwRxtVzgN/EkmPM2GNrh8lrT6PLOU+tTZd3G2nIIQdorG5GX6+Xdoa9hsiBWLVcrP8mMpmKPfx5kT+0rI+bAN13Ge66RfE9YhdRt3joIeZHFKPt9+Gy3OQ79+jAq5cTweZIGFOc9U=; 31:18htVaOK6tHZb9eC/+2j72NBdzBETRDXtNYI6JuJyA+QiDBaRHs4G36mtSVabVx1qpeiYLV2NlHI6zddE462hQSRkVUSR3cbkpL095vi99neJbnDtMGU35egYEvEv2qalHAoj3jgg5atm6i1eb1hwnwORzamPnOIby/KviQnvR207FjPqPLu3GNWTOWq2Cg3BIiYV9KKza6Eu3N9FhiHJGYRxC0XhmaQmxh7pDliEeZpN3wrirxtfL0TedtanoQCXj+E2Qqyzy2OyhVrnQirGg== X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0742; 20:QOmc+AkX2OA/3pOgYNeVqr0CT0abO8mehEfHkCH+jGr6YAkdT9Y1ggB3wmKCuhojnvrcT/4keISw7LCGXT1II0n4CccfeDB08VazRkwGd3R9KyH/WtBslvV5WZ6enCc4OoVX3uqzu0jPTsT/zJAUngjVHQizCEW4cra5nhazJm6YcGnWk7h+QPi+2nXF6/n1Vvmx2o616MOO0xN374G3O9hpDqywavIGHDZtbBMHbHutpU2CBsdrvrjvYVVOkFktipYYvlIwFb5aX371ynbrqmnVOgtiPzlXuZerG+7aV8jmKqnbvfB7dFrXv4kl1ddd/JDxHZqmB+jWKrd0KmJQeo9QC8TD3qA0cXZlk7QAJXXS0CrBx1IKo/P5OhrffR90YuP3/DN05eDu1aJZaeSjdySBtGUc6YGOO3yJTjqBbeRSh6WDcKXGZvFLnts8dWoVBNwThLvIuqCel7SKND6Ij0Y5By7+4XEP4xqIVvKLDEGwwWCbqDfamyo5zVmbNRSb X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:(158342451672863)(192374486261705); X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(11241501159)(6040450)(601004)(2401047)(13018025)(5005006)(13016025)(8121501046)(93006095)(93004095)(10201501046)(3002001)(100000703101)(100105400095)(6055026)(6041248)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123564025)(20161123560025)(20161123558100)(20161123562025)(20161123555025)(6072148)(100000704101)(100105200095)(100000705101)(100105500095); SRVR:BY2PR0301MB0742; BCL:0; PCL:0; RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095); SRVR:BY2PR0301MB0742; X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; BY2PR0301MB0742; 4:t7X5TsA07pDeTz9cXvxSe9XNZrMQRFNZm/cXgDW9?= =?us-ascii?Q?t8ESZhcp5/prNwv+XJLTxV9TitOvp0oim/kDoDJ2TK2+2mqF7/g2RyduRKs/?= =?us-ascii?Q?mtMhA7QW0cYAHVGfXDjydRNQNuZ6Md3P5CGHJcSO5XoXRSe0NSqyZ44wQrzP?= =?us-ascii?Q?Q7ZauF4UQP93ADq/oXENN3pqhx4GrcoosdJiC7ysW40OSw2ARg08tAhZk06+?= =?us-ascii?Q?uZkKyo0rFuAMVFw5CSVQdKvF6A8K0YdkE0wpGRvqfKFyCnan+lLCpaf+HPSW?= =?us-ascii?Q?NXJkO/Flnughtfz1jkI5CnWwLgeKMSsiWJA0ezQ6hwqLZ3BGUKgb8N9h1rbO?= =?us-ascii?Q?JJ7hJ/DMLQ4nyzR9K97byOkb3U+DB7UXyTx9iKKGnb7Mr0fEMrjihwVNCkTw?= =?us-ascii?Q?ewbQt9pXC3wd7NrWNSccdxm0qLi4SpXq7uUnWPzuQ1IWQ87hpTH14FxWA09B?= =?us-ascii?Q?81+q2O53/JXctMFdBOIHM34kBJC61KDehVdTQXhlxc1FPsNnG3cxeX9A1AoG?= =?us-ascii?Q?PrhKcDboK51HkkVsw0ECq11iGwvTKPva+SPbteFYdQ1MrWQNhidwicp3eDXg?= =?us-ascii?Q?NNxspUkbceJjCwu1aZFifPTJrBwhgfDAsoV3OXMrwf9ldZTr4BzJFB9aNZWK?= =?us-ascii?Q?tONhSgaJdkD48MbRVN7Pr6UAyiAIxxRkRmhciIF6ARXzFsw2RLDaEYoM/wQm?= =?us-ascii?Q?gFoikBK8ciwNmZkfGZmpPqqdI5jIP+4E5ANsIGgJUiAjaOHjNjfAY27klh1P?= =?us-ascii?Q?UdH3oovPeCNuPEyXfnut1YE2PE8YOjEr73tyVuLRJD/WUaH5fLIoiDthe+Go?= =?us-ascii?Q?LxZWSpi4iWiIM1/4TMkAN5ABA4AIZi3ij5PE0RK528JA7N5GHMSOVaQK2iop?= =?us-ascii?Q?BtUvlCpw2PJw2uVRM7zkqsN461WwvfY6Ofz2B/vYHWQLu1YhYJ0H5U7vAD09?= =?us-ascii?Q?k1K1DEBA7USxrXMtm3O0hvUT7iYk1yD/sNglFYdtcqintSkwwKxeY2LY2P/g?= =?us-ascii?Q?UjgkUh4W4zGSKtH1a9gT3p8yKKqz6NSNXtlDN826VJWkLw+cn3oKVsJpHrkp?= =?us-ascii?Q?M9XWAHxBb3rBYpwhiPhX7EKNYLJcBeyW4Y0W5lGTqvPXwXZbmX+40VeQ8Kxa?= =?us-ascii?Q?cUcluBfyigmOlYQm88vAwQmUgks7D3qq3xDUqUeZPq9W9JQ7LBeO7NKJCgz0?= =?us-ascii?Q?2bjO1FOz296THDm3He4dvgznyoqeL/sXWMD4eOeV8Ahkgs2uWgTFCTIbq0i3?= =?us-ascii?Q?izGQmbSE2kMYuRVWcTaZRTtS/Z2BXbKloTtwVmI1Tk/zSAvxoZ2iyGDovPfB?= =?us-ascii?Q?3bMDwd/vGvDtGbCNT+gYcvs=3D?= X-Forefront-PRVS: 0337AFFE9A X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; BY2PR0301MB0742; 23:7fhr7HatSj/pwHtFOTtTkI7FDpb0MLCfi3zdWN1?= =?us-ascii?Q?Znn1cDn9KNcrUQk9kGT96YWkkOSSs0FbF4wIsFPpFdFhCAbhypiUVFWhADTW?= =?us-ascii?Q?NjNQ3Cf0JhB6p4pDc2HAWONzoVR3qI0Yvfnj2D/PMzFXLav2o+MdiwI/I7/F?= =?us-ascii?Q?+f4PE1ZLQxM0POFLCZc+Hp4BxaBeaGpze0DzXBPt0nIQjYrLV8X1gd2D6ZWT?= =?us-ascii?Q?xEIgl6VxKXyS5KDoS2okviGYUWsPtn9C56+Dn3Nr3cnloSO5pZel1sYZHDvl?= =?us-ascii?Q?9ffnlCl3L5IwdmZcG88qq1To9gIVY58oY6VINAhfJdntW7cgsE+grZRh7HHk?= =?us-ascii?Q?eegan7jYBoW3+8jzbk3EJbG7SfvpHZnAmZkHmIZK0E39wQ4P6U/TiJ6n9wje?= =?us-ascii?Q?quyZ+B3n0O1q5zX+zvKNqjgMf4gG08JP8ObnfNMrFjUzRyxqiBKKHh2zi70B?= =?us-ascii?Q?OTs/+xKjFPgCBYpUAgvA7sIOkbNTsU33cFpHh2wjczpUVHMIInWPGLOeqDt+?= =?us-ascii?Q?AUEIJhX808xLpV6lOKuN3CW3ZdhS2xfqcH8eYrogL5SbdSwppVQ90/rIZhNG?= =?us-ascii?Q?flVbUcgvUiYmfZHOjuWrAMsEQvVCJE/nGEpVr6LNjq+wnwXpUPbQt2Gi2TTo?= =?us-ascii?Q?NqpTHGq0oOKPc/DT52QabAp6d9Z/rHoL0hKBXM6OPDyi+FcOaLXyMvKY+B8D?= =?us-ascii?Q?qR1IKVmcq1mo6wMSkNmBGXG4eWbO7SKF+Ga8AZE6+gBQ88Srje/2wllvGXmW?= =?us-ascii?Q?a8VpHrhOWlEcsIELCEizAPh625GBPCIFInnFjjeDUsVc8ypcJqnQC0bn5yTf?= =?us-ascii?Q?+t8Etpk0Z5yPiyckMVqIfYn/ING7KLStte6N0O7GGFEd39cOpV2dpjI4jxNB?= =?us-ascii?Q?y+PxV2HSmLmZIKgU7L33ve5zweKimvc2NNekOB3B3iqbJXsEIQqca58Dw1kq?= =?us-ascii?Q?sfqzzbx7DYvQfOB6MYTZNhQNNHmIQbAVu4rUvbf1NcERj3Ddi7T4hdPPFyWI?= =?us-ascii?Q?GuIrvUdHuwBof/pz2KUjVC/ekbF3o0qDpBZMCsZjFI/IVuA33h/DuhyJLFtA?= =?us-ascii?Q?JAFfeJy8sEPoImgvMmR4gc9gZu8P4Z5AGgeh3q//uh8fr//zi10cvmd4Ey+6?= =?us-ascii?Q?9jfVA1g3cNJ3jg5IXsasItrB7Nzynf1PtwRhvCbwW6Mbr3KemcHgsSSuSKql?= =?us-ascii?Q?G9AoEh4XawSC2k2JoG+Vu5932u0Xb4b2mxNPh0+gmMlshz8acJtLhkZG2ynA?= =?us-ascii?Q?oGuTFNjAWN8Nas//+Xq/rhsHH+FlC3I3xa7p7Zvv1W5QXIBXvaAUyi3y73m+?= =?us-ascii?Q?VsMbwZEXZHZOnwxv25L/CD3ZgDxBhiPC4fWEUDLCOPKMfHVTUnCVzPB5FHOU?= =?us-ascii?Q?K/vTYch2kqu/iXLTbFskHKL8xC0dP1oxv9Ty0KwrIU+a6O8rQuINvzxfKjMp?= =?us-ascii?Q?iNYn60FATXw=3D=3D?= X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0742; 6:w+Q58aQQ421QNQAVWn3oN08OdfLznlBxXzX/uokncT3R0FIOlOT6xJES0PJewqcX9nfHySz43ITutwE22WHu+sPgo4ecG7kXvUuHucRtIJEbGQh6hZk5v9bnqXlCvuF6tg9m4qqZ4HZ9cnetk60O8/TQ/oYvt28NWGT7yzN13CoFNtqfLrFAnhhua/itSN8wiwKF/QH9A1sZi+ZWT+vTQoRHSLnE5hro/jL+8c0CFiNJ4DPumY2dGylcTyMGbOGxB+RXn8V+7w7fMMiq1YG50CbwxTJHWCMXRE0PRKyciUZSrgEl90UiPUOxbwG+OxBvFLyNLyJ6iTuLbAAXmfl2I4G7KEHKbW4QzcwRzRaxroKEXiuCh1ZutM+mnstHhiPe6xMOk53c+p2NqzQ/vRZMGRO+PlFo+zl/11uYy+/823UfhdmJ8n7aYaYKfrRugkBn/2Al8wfLdFlzm1JdIu7gGFfeRLVcyg0/UfCpytdsMYmZb1/hgsnNA9e4rO2mnX+x6ISSr9UDATiXBw8jTFjEJM2RUXoJ2QlR+nGn6RWy33s= X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0742; 5:Xb7OuB7G6yJx1C69+JxuiCUbA8qH3pPe2qeeBcN44RmRtpyzwrI0SZ/pButzRY95oDAGZWHJhN2LaIec380970as8GkTGoErCmu+avDHVFrGdGFQ2gXhA4x9b5shbRcOX3J2nEoNJwriDhH0Ivm0BDIKv0jo6IVVge+C4WN8ij0K8g8RGdmnOEdkl1Vp0sNv6C2Rm3RoEjF5QTODHkMTCbe8bXRuXs/5VMAt8G7r0pW5U0+RAoC3YXSCaknN/1RBDxYvLNV5N9uIzXlzs9t9cJBkGjxftGhEdqoyf8hcYr9LC5RN0bRRnXp/eWjCi7Xx9tllmzhNfUxUosODANSBb/a1ZuLAIXDPz+KCgckdzi5iNoznbKMHMSWJGPeQOHoDp3ovGTDMPr4PHXxX1e8wWSrBPnehwIukqJ9T+eYx/tQg+aYlpfUX6TDFSxneEVSBc0oj81V+XzXn0I06J/I7Z14bAMjhGlVxABY1D0xNhud9q1Ci3SFiYPPILZdDD1wi; 24:o9lzbAc3pl9sLB82iOwOpeLO1QDGvX3Qp+z+p4BuSY39iVfmXchEgoraZrBu+s9ZNRHAHAK8mp7ePwurGJDRc7zn6AzMs5mRwc/twFin4dg= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0742; 7:8hQRGs295ZNn/7ZVLQS/V4BLC3A023OQfXZdDtKRqFVheCx5Y1zrL0rjpfcIr6d2WiC85gpoCND7Plj9gMXRfLH+b6GC3KAW/D2qsadPKHRMm07CxzyduwiKEs3LDqUQxetPuz3VKbZ0YsMQVknOCb5wT9Q/ljNIYbfOtLyGVOvM8N/ElWon1dBMEzGYKbPz6PSDVNlvE/uvZ/RdHDX8qJEepyisyIO4hqqKcdBrstklxFVJDpPKHHwaqTmKSRuSvGAjNRCu/mYxCzl91pp+1Znj2F7C9CnJBNWOKfDEfc9J9XjfXfmVVOAwrDVAkPtFBkW9r7m2eCgETeCt6OxVDA== X-OriginatorOrg: ca.weatherford.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 13 Jun 2017 06:24:36.2414 (UTC) X-MS-Exchange-CrossTenant-Id: dd63fb60-07f6-4d96-8d40-ebeca61a524e X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=dd63fb60-07f6-4d96-8d40-ebeca61a524e; Ip=[23.103.226.20]; Helo=[032-smtp-out.weatherford.com] X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY2PR0301MB0742 X-BeenThere: freebsd-hackers@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Technical Discussions relating to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 13 Jun 2017 06:24:41 -0000 Slawa - thanks again for your suggestion but, unfortunately, same behavior: (Server is Intel Core i5-2500K w 16GB ram and 2x Intel 520 120GB SSDs): PostgreSQL test results immediately after reboot: Timing is on. count ---------- 21568508 (1 row) Time: 53855.000 ms test$ uptime 7:51PM up 2 mins, 1 user, load averages: 2.46, 0.88, 0.34 test$ uname -a FreeBSD xyz.com 10.3-STABLE FreeBSD 10.3-STABLE #0 r307264M: Mon Jun 12 17:= 48:24 MDT 2017 aaronc@WFT:XYZ amd64 PostgreSQL test results after ~5 hours: Timing is on. count ---------- 21568508 (1 row) Time: 737626.512 ms test$ uname -a FreeBSD xyz.com 10.3-STABLE FreeBSD 10.3-STABLE #0 r307264M: Mon Jun 12 17:= 48:24 MDT 2017 aaronc@WFT:XYZ amd64 test$ uptime 1:06AM up 5:16, 1 user, load averages: 2.21, 2.59, 2.04 Perhaps if I was on stable/11 this would be of some benefit. Regards, A -----Original Message----- From: Caza, Aaron Sent: Sunday, June 11, 2017 10:33 AM To: 'Slawa Olhovchenkov' Cc: freebsd-hackers@freebsd.org Subject: RE: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD perfo= rmance drop < 24 hours Thanks for the response. I happened across r307264; however, my understand= ing is that it applies to the FreeBSD 11 and I'm using FreeBSD 10. Note that I have experienced the same performance degradation on a FreeBSD1= 1.0-RELEASE-p1 amd64 system using 2x Intel 520 SSDs in ZFS mirrored pair wi= th server an Intel Core i5-2500 with 16GB ram and running PostgreSQL 9.6.1.= There's no memory pressure in any of the systems I've tested on. -----Original Message----- From: Slawa Olhovchenkov [mailto:slw@zxy.spb.ru] Sent: Saturday, June 10, 2017 10:37 AM To: Caza, Aaron Cc: freebsd-hackers@freebsd.org Subject: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performan= ce drop < 24 hours On Sat, Jun 10, 2017 at 04:25:59PM +0000, Caza, Aaron wrote: > Gents, > > I'm experiencing an issue where iterating over a PostgreSQL table of ~21.= 5 million rows (select count(*)) goes from ~35 seconds to ~635 seconds on I= ntel 540 SSDs. This is using a FreeBSD 10 amd64 stable kernel back from Ja= n 2017. SSDs are basically 2 drives in a ZFS mirrored zpool. I'm using Po= stgreSQL 9.5.7. > > I've tried: > > * Using the FreeBSD10 amd64 stable kernel snapshot of May 25, 2017. > > * Tested on half a dozen machines with different models of SSDs: > > o Intel 510s (120GB) in ZFS mirrored pair > > o Intel 520s (120GB) in ZFS mirrored pair > > o Intel 540s (120GB) in ZFS mirrored pair > > o Samsung 850 Pros (256GB) in ZFS mirrored pair > > * Using bonnie++ to remove Postgres from the equation and performan= ce does indeed drop. > > * Rebooting server and immediately re-running test and performance = is back to original. > > * Tried using Karl Denninger's patch from PR187594 (which took some= work to find a kernel that the FreeBSD10 patch would both apply and compil= e cleanly against). > > * Tried disabling ZFS lz4 compression. > > * Ran the same test on a FreeBSD9.0 amd64 system using PostgreSQL 9= .1.3 with 2 Intel 520s in ZFS mirrored pair. System had 165 days uptime an= d test took ~80 seconds after which I rebooted and re-ran test and was stil= l at ~80 seconds (older processor and memory in this system). > > I realize that there's a whole lot of info I'm not including (dmesg, zfs-= stats -a, gstat, et cetera): I'm hoping some enlightened individual will be= able to point me to a solution with only the above to go on. Just a random guess: can you try r307264 (I am mean regression in r307266)? This message may contain confidential and privileged information. If it has= been sent to you in error, please reply to advise the sender of the error = and then immediately delete it. If you are not the intended recipient, do n= ot read, copy, disclose or otherwise use this message. The sender disclaims= any liability for such unauthorized use. PLEASE NOTE that all incoming e-m= ails sent to Weatherford e-mail accounts will be archived and may be scanne= d by us and/or by external service providers to detect and prevent threats = to our systems, investigate illegal or inappropriate behavior, and/or elimi= nate unsolicited promotional e-mails (spam). This process could result in d= eletion of a legitimate e-mail before it is read by its intended recipient = at our organization. Moreover, based on the scanning results, the full text= of e-mails and attachments may be made available to Weatherford security a= nd other personnel for review and appropriate action. If you have any conce= rns about this process, please contact us at dataprivacy@weatherford.com.