From owner-freebsd-hackers@freebsd.org Sun Jun 11 16:33:25 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 782C1D8A542 for ; Sun, 11 Jun 2017 16:33:25 +0000 (UTC) (envelope-from Aaron.Caza@ca.weatherford.com) Received: from NAM03-DM3-obe.outbound.protection.outlook.com (mail-dm3nam03on0065.outbound.protection.outlook.com [104.47.41.65]) (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 F10DC6EF99 for ; Sun, 11 Jun 2017 16:33:24 +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=hC2OgNrG1nEfZB+bQ76YlLKTiTNvamG7iunJJuZ+6YI=; b=qG2Bq3Tjhi8tjAPJJS7YECKZ19Z+OdbWXXc2UnfhFoHLlEzy4tVRSaaFdTHDZYPdzHerEfRQA98pUbLOoYrzN0iyvJsifyduPjDi9PWmVz+gBwyMseMQWU5FrkxKXD4d+yJmFWPMaOYVWLA1yNmVirMF7KCWjWY8A2hRrRzJCVU= Received: from CY1PR03CA0009.namprd03.prod.outlook.com (10.174.128.19) by BY2PR0301MB0743.namprd03.prod.outlook.com (10.160.63.21) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1157.12; Sun, 11 Jun 2017 16:33:22 +0000 Received: from BN1BFFO11FD027.protection.gbl (2a01:111:f400:7c10::1:144) by CY1PR03CA0009.outlook.office365.com (2603:10b6:600::19) 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; Sun, 11 Jun 2017 16:33:21 +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 BN1BFFO11FD027.mail.protection.outlook.com (10.58.144.90) 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; Sun, 11 Jun 2017 16:33:20 +0000 Received: from DM2PR58MB013.032d.mgd.msft.net (141.251.110.81) by DM2PR58MB013.032d.mgd.msft.net (141.251.110.81) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1157.12; Sun, 11 Jun 2017 16:33:19 +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; Sun, 11 Jun 2017 16:33:19 +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/716RidAABhQ0AADIocOA= Date: Sun, 11 Jun 2017 16:33:19 +0000 Message-ID: <29f90e91bc05472d986b711cffc98c80@DM2PR58MB013.032d.mgd.msft.net> References: <79528bf7a85a47079756dc508130360b@DM2PR58MB013.032d.mgd.msft.net> <20170610163642.GA18123@zxy.spb.ru> In-Reply-To: <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.68] x-ms-publictraffictype: Email X-MS-TrafficTypeDiagnostic: DM2PR58MB013:|BY2PR0301MB0743: X-MS-Office365-Filtering-Correlation-Id: 536d7d9f-3ac4-4791-d0ec-08d4b0e7929c Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OrganizationHeadersPreserved: DM2PR58MB013.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)(39840400002)(39860400002)(39400400002)(39410400002)(39850400002)(39450400003)(2980300002)(438002)(377454003)(51914003)(189002)(199003)(13464003)(24454002)(9170700003)(66066001)(33646002)(22756006)(7696004)(8746002)(356003)(8936002)(24736003)(47776003)(108616004)(2900100001)(54356999)(76176999)(50986999)(229853002)(305945005)(7736002)(5890100001)(189998001)(5660300001)(4326008)(86146001)(38730400002)(110136004)(55016002)(42882006)(2906002)(6916009)(2950100002)(72206003)(3846002)(53546009)(102836003)(53936002)(86362001)(6246003)(23726003)(81166006)(46406003)(97756001)(478600001)(8676002)(9686003); DIR:OUT; SFP:1101; SCL:1; SRVR:BY2PR0301MB0743; H:032-smtp-out.weatherford.com; FPR:; SPF:Pass; MLV:sfv; MX:1; A:0; LANG:en; X-Microsoft-Exchange-Diagnostics: 1; BN1BFFO11FD027; 1:Jam9KOKL4Lyyg7e9mjykuQczog9G2Cc7fKZDWctJsYl4r5BdHw+P+hZZI1vXxD54xPh2PlJX3tSIxk3ts5T4uXA0IpfzYfHoJNCIClfqxbeTo16SaeIZ8NEg8xilZszUX51IqvIuKoQzFXAV2NZDJCVWyO4iA2oVTOrvwX6mqHQnG3f5E/bvrnbLD3ZO/WvAbZOZDwLYCLvGaj18uR+Nk+As0g6xlhwQb4//cjw2boHkQdpmIgPmh5hir8e44RzUe5kCPZMEuOI++sqWXXf9InsSyRc6U/x8igiL4CRvc6C7GGA6v0tjN2vgNqBwjQTMT536XAPH1NkHUbFlCtMyXDTiW6hCyW5pf0poqbel1sGQ+S7FCTJf5SQGeJqNSnRQef0eblE1AZPZA60YfUdHGvzyjG90ShAxfz064bGKmQrn9KqdGLUSUO0SdsmCFMsBEsjg9jzuo1UZQsj41UHwkS/0wJ5fG9/UUOIWywL9W5emuI+xCXdK6fOHoHdpLxsTTuQhqVQ2Cj0edUKBtPP6Dw== X-CrossPremisesHeadersPromoted: BN1BFFO11FD027.protection.gbl X-CrossPremisesHeadersFiltered: BN1BFFO11FD027.protection.gbl X-Microsoft-Antispam: UriScan:; BCL:0; PCL:0; RULEID:(22001)(8251501002)(2017030254075)(201703131423075)(201703031133081)(201702281549075); SRVR:BY2PR0301MB0743; X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0743; 3:ivXPuGqgTswtVz1qnLlrleP/4FV5tEyoSVLH/p7fLEGeMx8MkXUzFJfOXwEfUfdwNoaTenW3M0WFG1c4m2Vg33DIWa5FSB5RzEQRv80Mgx1AAHz8LcIEYfkIMpNeSO2LC1dWyAIpd+nAZDdRvxWGDgfqZ1QFSz9Q6p7GBvtf2nlg7eBqMYEcghOOjltV3GBeik0DA8ovTTYkZ8l22NUXVj/9C20Ef6MNrh5e5XviiM+13t2grImTjiCtkqY35orLCeIzmEjVzWCXDj3TqkVUNSHnqlakGbc/g2TSN1Re1a/TpuhwMS4KT14ftpD0sTLy/1A6bdiIQP6QR7a+SGb5LgY1UWD3mt1BNGUxs96Ro/ylJ8oIPqz4v6Z7SkxJL7tmkMKItus4eq1uuDTjph4TRCFtn6H2o41KBaqZ0pup7Txj2TrcMwkVGvg+4eHdVjwRbJwd6y63b2gEx3FuPcQbIfK6IOZY/18FcdAPSsOdLvaVhqbf72eWBOKcvCRe0qAvNW74n0Esz96+/ub+wvxwew== X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0743; 25:LA/4n91DDAAraFqTymeVJ36R4xmcZQgTt8tR+bOW9nHoqIc2ZMyu6DFK0q+bpgV3hnqBOT+q1jbRr0c8a6+MsbGzjh8HBCfBDqrm5g80KeW3frLyIWrY8R1zI2T5cPTB6cDOAA5qwC5FBz1ACJynxLR5gnSGHldVkwPZj9dk2e/i3eyHS1QXCgJzmalki9OCHbWwJBND35G2ZRdgQIR7H4EsQnsN2Z5iPz20Uf54PXC2RJQmTXemFBc5bq6Tx6eMygDY9IyIO+xTa8xR1SD3/ELlyJoexU+bSixa/cQGajLqVbfp/BWZLJcRwJ0br4lulChHRlGhhY2vVT3YfVHZMYfPxIMqmzRbw+rfXbOknTfe6hnW6pDqEq323Jo1QsHsAnKi9ZS31FHWwZUq9IhrakvuZKXu45t3+krPHwyIGOIR7J+DwQeMrS8WRAFK9dSMffe/3YiLultk3eEe/+DskbzYQHdsSeL9tIgDW+Vzq40=; 31:iulUbXbROdlAZbeFqJCM9ogu2nvM8gp4s50JDH94V9SblWZLICPxuxQGqoECp5ZqUGr53rBalZu2U0sWVDa3cfGSmCN1WLIc8A9iZioDBLwdT1m6EkdgQXcpBphHX3exbz4sAaK133kuJd02EFI4q0FGIt8XK/PIlNuwAYUwMb5gngcmiV/5XR32IyGlr53hxd2Jm17DI4KvS4iJ4zHX/XXUaIW7a2A7Pvx7BzhoMx9fiCw6I0ZpyHqTrujHFCMrkzKDRcs45A1dfFroX402Mw== X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0743; 20:oz8aCkgU7RjF8dsv/IV1yqZDwaWpubIGcTsi8sDuokI7jVoBI/yx6dA/d/ggdVF4I/BewjtK0kqPxilU7rJTQBX4r5JEkL6VJUeOSgwORfgPzRpV8gcIAIWCd5g0pS1ORn0KkVYUTat7zRHnlW+kMfW+rztcjW5Kc8xRvRGyZ4negwrpZCAVMcrjIPdAEzu/H3UKt6sGXQghfty4UMVHTbI8IgoQSm8M23XvjdLmhFOgXsA5qADSytzABw0mJaOgmFf2tQYD0NM3/ggBiLUPJC7r0e67UjdW1VXel5MVMgnsCO7gOKUdAip2eKtycvTwM1NZdNgZ0xpID1qDwgwhdHRot471JhSu90NjAKw5K42tVdgUPIDDPnFeM7HlTdt0MldzFe7EL8wJXhzJXaD0eSVaAPCLceJSG9orCj2BlXf89os1kTmnyVtMEgJP003Yn9B47PmSxtIZKcu/dLzoI4N/fwUrCxDsoRYIlQq2S8Cfz39UKBUiQuAKHS6epZ/j 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)(13016025)(8121501046)(5005006)(93006095)(93004095)(3002001)(100000703101)(100105400095)(10201501046)(6055026)(6041248)(20161123555025)(20161123558100)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123564025)(20161123560025)(20161123562025)(6072148)(100000704101)(100105200095)(100000705101)(100105500095); SRVR:BY2PR0301MB0743; BCL:0; PCL:0; RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095); SRVR:BY2PR0301MB0743; X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; BY2PR0301MB0743; 4:uxWKH4/oydCLtFFDlfyVXqluc1DMj5yCIFw4QyHZ?= =?us-ascii?Q?dTfRmqx4xsyN7IpLcb7c0gC2gTDItoJe9wYd72XJ3TDv47R1LvX4cQOzKL5h?= =?us-ascii?Q?LHwVaEvr6FCuPX20YhjBe3ZEX3xcBMAeDqzOb+n7XldnXrFsdManjO13G9sE?= =?us-ascii?Q?QDP+Md7PY9IfW9nDZXVLkhMfxc0hoaeJQKBNq1g2Z45AZEFagEdc9JYc6/kB?= =?us-ascii?Q?a9zaw0rQcz0v7V/TpEt6AYKpJQEmnzauNqMVI6De4tVi3reOOymf/ByxuN+C?= =?us-ascii?Q?JEBcb2iE0uxB3BHHt0Lq/K/VHB0mF8LNAQunaES5jVaADoMIZCl/xd2pS8am?= =?us-ascii?Q?zmrUWH4yfLXazAT8uTcWWSd/SqCryH85WVPbX7w+pLLFraiqAT4lFPMcvzkQ?= =?us-ascii?Q?1SyMy/j6eBpOv+0XANiuHjtJc28r+swa612NoRvl4uTBCX2gf5xidv4qTOnq?= =?us-ascii?Q?Zv17odGP60H6xGShcLsDEu8bAHFSi+C2AfU+YlgKs9y8G9g29WcHnTbzKRK7?= =?us-ascii?Q?0CFOBY4C2ayX90qeZ52fdBT4OPKKPED9PzotSpgl1eMnjKu08umpAf3Lt1Jb?= =?us-ascii?Q?AjXyimhQYLgS2QaAw4y7PLU/4PUP/+JuMH/q0UJDzpOM7O/df9o2ayt6CH+E?= =?us-ascii?Q?t7o3xm8GhX31rdPNqf/8QBvYdVllSwEwYi3H96poU5bcNGbN8X0FSwqjgaDo?= =?us-ascii?Q?JSTCmUGrbUy+WIKBK1ym/skEVLSRt2e0KScLh+F3UoaLpcj3rrWk/sgAJZTq?= =?us-ascii?Q?CsQ27NBD1SbZqzuq8Gzyo7N/TEYdDe+rCyj32QxIgMNXcMV3faXuJNYFH9YG?= =?us-ascii?Q?I7P9gqh+iqwhG8RVOhdS4xWcf/Ldaj6HwgABssgJIA8u0zWVJYN5gr3cM2En?= =?us-ascii?Q?a4Z1LoBqHKpruKATLn/7vIsbgtnn6pJbuO/C1Wqg2ynNz80H6KcoA0y/kQIH?= =?us-ascii?Q?Vo/GwyV8aKdkq3527/YhuHJByoNgOtkvTlODtW8HGKINeb8ZtFdO9mKL5HGb?= =?us-ascii?Q?uKSGlqvQ+TOyH5EQecEJv9qCzX0JdmrGbodz5IaSCw/u4MHiEG2A6buCsvvo?= =?us-ascii?Q?nq6J5iJEAKhRGCqZ8b2R++DVB3Tpv99EafJyBGPlZ+e1MEvo9DZjmfebDsE/?= =?us-ascii?Q?Xb2nw8styr0rgt067Qx6tax4JM/qHbXeKrDElNqW8cV80YuAX4SoUgZg0ff4?= =?us-ascii?Q?XbGSut7HINahiavYsG/+ov70bMpPCexyZ3merrzgw1y6hUIbh3ylUwS7VflC?= =?us-ascii?Q?mDhlDV4kXygIjkgYvVCyx8ZnuFXNWyYvvUz/0AQ8Mm8FQ1rudAQDTQQJASI0?= =?us-ascii?Q?Tmb1CM/EITrx0FfYXVnKLis=3D?= X-Forefront-PRVS: 03355EE97E X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; BY2PR0301MB0743; 23:i9dYIXXELw2moJsIKvcD/wvWcqDyaHGZrTnKNmE?= =?us-ascii?Q?oNNxWm5inZJk8Eeml/3enLG4Ru3sbdxabxozkFBb0g8cjQwAvR0f5b3SZdKf?= =?us-ascii?Q?Vd16QT4oF0k54KwKvKUsZhBwfN8voxL0cI+H9zXvjmfoxIB2qKVvI71sGM4B?= =?us-ascii?Q?vEYW2frZSY2F0GLBp42/ErGtremeW5oeNeUhxBSLi9v8R0kf7zP/5vCwiPTh?= =?us-ascii?Q?ROOhzQsB22g/HwCJ7C4Puf1X0ymGfFusT9z3ZiLSKtwntJMf/ynvLsDo1wtI?= =?us-ascii?Q?UuaApdrZ0YfGExtxzFZSDwN58SO7dtmAQSj/wr614zhnsZnmZiv/s69lPy9t?= =?us-ascii?Q?sDPk48UMYzFOOU97fL/zx6evmSTKbxagtSzOCGxaPaw0rk2pVyD2ln5zejmj?= =?us-ascii?Q?i1NcaIELYo98okOO3Y9KJVsi6q6o29T9UP2inUtVbe0Wcw5RY/2s1EJGhdRa?= =?us-ascii?Q?AGMb3TfWjE77CupKsjrkCXkZvSHKS0U3p2Yqzz6ey4NqgALIoZgkc1G1DQDi?= =?us-ascii?Q?eRh98IJrQJDD6SpK/ZZZuLpfv2+mB51aW3sCx0cDeh6Z47SBfq9hCtLkJTam?= =?us-ascii?Q?v4vsUAXf3kSKl7O5dZv5/bnHB2m2NdIMrXSXsdm7wjMQ7/jPRfMnfvp3DAu3?= =?us-ascii?Q?Bh5cpRN9hVnOPm0XazSlHN2tVqE+mDVanfWXgSJ9yZMTy0NIzhDB0/0hxfLM?= =?us-ascii?Q?m+PX0pUqakQgIEvjcXoy3CpS1MirlAsxT6X5vRdpycOvQz7w6tfaAqu63liN?= =?us-ascii?Q?ehJh/THf89NKvNAqkERpDzJ8wszviWTYED7XLGGycIpOw3VRlWhFM67Bm/lb?= =?us-ascii?Q?TMYD3F/rh45bpT3apf8DHg7AuOnS4yyfm1YGm0QwkUrU1SDi0IjuM5CIy5Pg?= =?us-ascii?Q?fCUHO6AYFnxZqd6QTO+7ArAvmCrPxGtAU1Xvt+CPADhGsGhqYzvMMNyFIvCx?= =?us-ascii?Q?BHuBmQLQh4Y7stcAt0MvRRkhbbEIyOFjqONk48O/lgOoMKD25horjhuByVBC?= =?us-ascii?Q?BHoG7sIdEw5U5pmz1H1OatvGoDl027Iq0YITsc8LquTDSgNJyc7nqKwN3FMx?= =?us-ascii?Q?eKw7mNwQC+pwNZNPC/wwmtpj2T9DhGOFp2XU3OG3j5uB7QjnEodLDTEuRb+F?= =?us-ascii?Q?Huosh2/nwxT3gkrTZl2O3zyiLRZHUX2CRCOHeYc/LFKGB+DecYXmA4TiUyl0?= =?us-ascii?Q?MF5qIhbc/PRV5Z5YIV9TjueIz/Vk2zljEjlIPcMoDjpXmH/0MkKyvJnSlBNQ?= =?us-ascii?Q?K8YG+4A5YqrUp1UVaun+Ww+1KkeT4tw26V+JnOPUFji7VNEnNo21rur9+smO?= =?us-ascii?Q?9HTaTplKu2PtM0/Brj7mBg8r963/RQRCGSjd+jaJ7R3aROSJb10FKKklmd+I?= =?us-ascii?Q?BUbGA37aeIP7wPeCqjdtGAb1/57NV4bqNKetvJRNpjAaXepUd6rKy2AHhoa+?= =?us-ascii?Q?JQ/ez75hnJw=3D=3D?= X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0743; 6:NCkiXzc70PjR8Wa5gbYGj1jJ036UQlrc6W9skg+VTJcDguR7KO7NcCa3ciO1otIfkjEtghVj1Zkly+QDT4+7K2z6baoack7yyUyfecOcq0+vhkk2CiqUAJyDJmR1w040gvj15ApDPZge3N04j+H/MGF5SP5XqKOhirqLDWbaU4HUpXtKjmGFUl3zX/5qMrWikGdcK4UXTEScII9X01IOUND8D3kLK0QJdHKINqhYQBcBiR72D3jVs52q1L5hfd9h2NeF6vvQ8ntLS1aBd8D64xd34YhRQY3BxoLVAR/ei0wf4SsWcKgNTzPDCgAzwqolosizsxpn5ES9ni4jiM6Jh4WT9YjJIO8uRfsDkdbRzd+nxS2S2AZjN1cSO8GiJR+KllCMWXn55BzGXBc61orvx8seMcJiPDdFrrxhfHaZqGH7qh2lK2cPEaHeea93KUFv5FMlqW3s8iut+JlLEwEmR6UEsIrcS3iTL0S+F4108reMhaIZA8uz5QeS4/piF1uL6Gsr3AE9vFwkqHVrjqI7GttOEleL2YnDpR0rMPjVMMk= X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0743; 5:VH5XluJZpzvxo8w5vNpgkaBk8G86SEsuvpvC2hAm5Uhrod5yNPbNYyHNBEqAol03tyjC+Csw1lkY4yxIeSeYJFGDug58iBaBsr5Sxlao7/KUqJvbPBqXftuwZTF9tYN00iyOSAlq7PmJMGmZALO3aUtDZxKvcjEKiBIDItMk9JzwGxqmJiWtBeLXE8CEzNGPfxgC94dNbUb/f8TSNb5ZeuvpjmC/K8FNn7nqy4aQTHuW6s2uDA3C3tBs76fzp0dOgjw6pXqQwI4NdzHe/Wa1VI1XzXQuYhb9xVkt6Eml9JiXWBoaVcO7cVvD7EvIvKFwN/xN/05xDhm9rxGmDJS00OiwE7llrHTUbIcJ9GSLgLG96wFqQOuZRJ4WW6BAjoj8hvktC1APiIZ/7sdnEDZL0dpv7+6Ff3mW2X6qTdXPOoWRXiVaCJ9cdecZk1CooIblkHEDmzomLLTDIoTyH1D2b37NKvSW4UKXD6r+R9nRcd/DxtCrY6adrhDLPaluriAU; 24:26ycGo2PqwS+22ghaIz1y+JCPgZYussnxzQIdIjaEEz/0EgGjLteRLF38Wa9lfKLVN6kfYeMGFTWQ1L3/tOKgwRcAcFVn/LR7IZ9S8r4fSw= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1; BY2PR0301MB0743; 7:rYWLxHVDwYer2af+MTmzB8p+rAk3yn90hAjCgJ2ygNgNaTH2Jf78mA7JkphEWx8PM5jpwUtjilLpGhbJtotHe71532nte/ohygtZyjuTiyZ8bMjww0TNrxVzk6L+UpX8PuDWH/d4G7j9DSg6E3tHHJeRxhLGstTHqgg6tYMhrB78y64b6Q7JgUFoDJN8Uh0WzPyhCnSXsGIaaLL+2uI/VeedbJKPARLRislu00n/3O+dMyx/5GIILw6Z9wjaTzzZtUbV7nJ/0mAf5zj8PrkNq4bdUHJkbcIYqdlOkFEUJMyxppiFVhUZKIzn56FHtMTIvLPZYkSvLsuFS1OqG0QaPw== X-OriginatorOrg: ca.weatherford.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 11 Jun 2017 16:33:20.8987 (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: BY2PR0301MB0743 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: Sun, 11 Jun 2017 16:33:25 -0000 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.