From owner-freebsd-hackers@freebsd.org Sat Jun 10 16:26:04 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 40693BF124C for ; Sat, 10 Jun 2017 16:26:04 +0000 (UTC) (envelope-from Aaron.Caza@ca.weatherford.com) Received: from NAM03-CO1-obe.outbound.protection.outlook.com (mail-co1nam03on0053.outbound.protection.outlook.com [104.47.40.53]) (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 B6E637E710 for ; Sat, 10 Jun 2017 16:26:03 +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=xi15YLjR1z3RmUovYpnpoFIEKzgaL7X2jik8wPtzRWc=; b=Z6ybsmzdHgNVDmnQoo7yV/qT0MA7NsjKgSlyUOtm+GEcft1YHrcNWUwzErUzPL5QaO3FU0LbQv+i2FqFDRvRhAvzjK+RxtUb+C5o8ibvKcFkGumfVBQAeDh3XyZHPck3Rg//QvTTSuySJklmrbDj3Sw/mlX9rIolwTlsdLVkV8M= Received: from CY1PR03CA0031.namprd03.prod.outlook.com (10.174.128.41) by BN6PR03MB3089.namprd03.prod.outlook.com (10.174.94.18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1157.12; Sat, 10 Jun 2017 16:26:01 +0000 Received: from BN1BFFO11FD045.protection.gbl (2a01:111:f400:7c10::1:114) by CY1PR03CA0031.outlook.office365.com (2603:10b6:600::41) 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; Sat, 10 Jun 2017 16:26:01 +0000 Authentication-Results: spf=pass (sender IP is 23.103.226.20) smtp.mailfrom=ca.weatherford.com; freebsd.org; dkim=none (message not signed) header.d=none;freebsd.org; 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 BN1BFFO11FD045.mail.protection.outlook.com (10.58.145.0) 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; Sat, 10 Jun 2017 16:26:00 +0000 Received: from DM2PR58MB013.032d.mgd.msft.net (141.251.110.81) by DM2PR58MB015.032d.mgd.msft.net (141.251.110.83) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1143.10; Sat, 10 Jun 2017 16:25:59 +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.1143.022; Sat, 10 Jun 2017 16:25:59 +0000 From: "Caza, Aaron" To: "freebsd-hackers@freebsd.org" Subject: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours Thread-Topic: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours Thread-Index: AdLiAalX9ncyh3crQla1B5/716RidA== Date: Sat, 10 Jun 2017 16:25:59 +0000 Message-ID: <79528bf7a85a47079756dc508130360b@DM2PR58MB013.032d.mgd.msft.net> Accept-Language: en-CA, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [141.251.136.132] x-ms-publictraffictype: Email X-MS-TrafficTypeDiagnostic: DM2PR58MB015:|BN6PR03MB3089: X-MS-Office365-Filtering-Correlation-Id: ccdb28f1-9daf-4912-2cf9-08d4b01d61b9 MIME-Version: 1.0 X-OrganizationHeadersPreserved: DM2PR58MB015.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)(39410400002)(39400400002)(39450400003)(39850400002)(2980300002)(438002)(199003)(189002)(9170700003)(3846002)(790700001)(5890100001)(102836003)(22756006)(108616004)(5660300001)(50986999)(5640700003)(24736003)(72206003)(8936002)(478600001)(8676002)(81166006)(2501003)(7736002)(54356999)(66066001)(356003)(38730400002)(6306002)(55016002)(2906002)(7696004)(33646002)(6916009)(189998001)(42882006)(2900100001)(84326002)(53936002)(512954002)(9686003)(86362001)(54896002)(2351001)(86146001)(110136004)(260700001); DIR:OUT; SFP:1101; SCL:1; SRVR:BN6PR03MB3089; H:032-smtp-out.weatherford.com; FPR:; SPF:Pass; MLV:sfv; A:0; MX:1; LANG:en; X-Microsoft-Exchange-Diagnostics: 1; BN1BFFO11FD045; 1:IM5BgDcorDN+Yc2E5ii2mF8KFeeclFlYQGmoGOPMH/IEMOkL5qH1TGeu0Vox/O4P5HrXwYV/l5ELG3lJaJWURfHRr8feTJmS73iYjJd1c5A00TAt/bXq9+P0y4fbC5SOcNJY8g5Z87x3WtQvAuzGn7uJ4QWF0b7/HTCF4oXkP6o76fRi/ppMisAvxxHjE8TW1zGbZd4hVNKg5fNVTv1Y7OLyg68apq7re9MxuCCacLuqGRQCuylRIUfOIjBuDroN8q6y+hBVcPKziaPLNP88vNgCk/g8nUh5255xaE2YodmvSlnNtgd4GR5OUtoN5zz2uo0X+aXqf148u/5cl9nDM9aEx+uAwjTQexLnWnzcmiv8S520E7PmDrVlljDWMfXpBOgWqzJ+EexZ0F38C+PW081RatwDGCOe5G+PjsTz2W13kJVnFvT7zF6d5Tw/xjsWvyzBMu2fgi5/g7Ie9cWjt+dbf8NdSVZyivLn0zPubfc/9SFWBunOaOqW7/JnA2bwSvdkZANj2y2dbasR0rtAtw== X-CrossPremisesHeadersPromoted: BN1BFFO11FD045.protection.gbl X-CrossPremisesHeadersFiltered: BN1BFFO11FD045.protection.gbl X-Microsoft-Antispam: UriScan:; BCL:0; PCL:0; RULEID:(22001)(8251501002)(2017030254075)(201703131423075)(201703031133081)(201702281549075); SRVR:BN6PR03MB3089; X-Microsoft-Exchange-Diagnostics: 1; BN6PR03MB3089; 3:o0OB+mz2TyPdPqLbDiJoGauXo+/oL1BmhvMlQAR4/rdGaYAh0q/R41CHq0SinaCkdOAP1lzRZJ7zwFEoBeVkVt/NLFvpvRhwcErRofv+AG+AzjCNaRwvETXUYL7VvBllSmsqwVtDe+c7Bp39+Ca1BfLu3PKpxYELLaa4WigYRQTBha+OqQUaFcJ4OgFC1Oefbx6w/GWjs/Tltb3LgpO7ZKTVJTzuzfrFdjmAecR1V4mikiZf4VElK47zxv8IUZaM+mtS+y7P4FPW23xXFZTlvlKa3X4uyBM8lc1s//ciMgcvFIa+O57R5G5DUoF9JG3pqTn9xG1Hab7e1jl3e6LQ9yl5h41r1zoC9pwomCYzcdhej3eWxaTUh8MmiL405yb8zwAK9h7cBZdBXdzYGgbWPDsh8Ekd52E9DK723pIF5O/dku7Jqg7DwvSpyTxzXfjrLYGCsthmY9VKE31aVwKXkCeluxeElF/RJDFjyKj//EmC2W6fIgIqZFo6cltuLLVb9aYUNWRxKPnTEgt1d8Rxwg== X-Microsoft-Exchange-Diagnostics: 1; BN6PR03MB3089; 25:j3pjrQsIuY8TgIdI3K1aVJko0YJtp4nGYDp54u66QwCkFI6TcsAfVKELJ6E1J3yhQZszWwIbKj5fVIwcnb5ZweVf0yaA3A356a/lQmoWa3uekiEJHcohv/rrl+dXkJN7qTwPhFGWO4hab5Yi2D9NXUo0H/R9EvR7wQd4d0X/gWDgVTfonNVjCTzP/trPe7C+y7sNSNz+PjqdiwmtQDuSYNihZOUB24DwmPE3U3EJaORoEc2q4xApmT+n5qctjKrDM1FL3OZkdiSw9Mh37GHpkDSlVFpUzLyR2HgBOw1oISgdYO4oLp+tDXiSV8P4NIjNEO9lRR2+juEOUrzfbAvLuxYh4LU7wlqmBiRXiQ7pELqJw/oFN/ZZSlKHo12UvCuM/GCUjrj2q9tLYu/22NjgrfwFfXrGHuYnfx0oJtpQyY9VY9AiFv7DiInMao25Gvv5YEmYHHEnLLYnPp1ECg8azU8w+EwMAWRfD19zIczt1Ks=; 31:7kPWR79c6AYbs+SaehzVwyuKg4/Ccc4A2cmOxrDCdKFYlivcrF02F7O96kkExfGfw6JzyInbgrQqNUaU+bifMqeLDrN7mnORBlSGxQm7Pf6izCKDICrDA+J2HdKy3mPagxurbJPOW7tRe0x7bGpnlQV8HTTv+6iEEhRIOLiydU1FL5ZLSIxJ96CVRIMeYQm6jaVr6Cz2NSHhuAL9+P9qHHESKtYqs67sQwqII/2PelbB8KH80KRdglOjwqxRhAkf3HDmiI1JpvzqfHc6WVoLEA== X-Microsoft-Exchange-Diagnostics: 1; BN6PR03MB3089; 20:Ppmt4EtPbnWm8ZxRS2zXSBHOJKAjs8EM2s3NucdQDov5P7bNvRfiwXe3sQa2UEpSCvhxGB/sJLL6nxE7o2T1OaK2bnN/x4CIqpQSn5NWC1kam5NhgsHc4AZXcTocbE4yzXVVuZWtu1O858zs+NcpTWZ+Sgw/phyl4RNcbnhfp9Xbaqux6Y6VKQpecHJv79MGnfh/rTsN7uUCvwGpnnjL6HnaZWA/+m0mIiWVCqaUjl+qff6YbYRxkwvT2RGAE5zTyGm+GdaKknMlGz0CLyYnqADQoMbmPFG5SQu1BgXnpwG8R9e35WPMR5MaM1ThfhI1Hkft+tuI81I0GMPF+e1cx+9iTKD1s0sKJanm5pG+9yQUmhIazmPeUYysW9L2y70MlDeT8lfDHgfusZqwDAAek9Nwa/pNtPkgLdskgVxtdVPziIdOTYLxPcUCEe2+ETgYuH+9PkP9BI6It9VebaD/qzDPFFoppen7vGQHYtiH81LNX8OXEQGFAxKU/0fo8ZZ8 X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:(158342451672863)(192374486261705)(21748063052155); 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)(20161123564025)(20161123558100)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123562025)(20161123555025)(20161123560025)(6072148)(100000704101)(100105200095)(100000705101)(100105500095); SRVR:BN6PR03MB3089; BCL:0; PCL:0; RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095); SRVR:BN6PR03MB3089; X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; BN6PR03MB3089; 4:i8pq3EbHN4bfjJSxIV8+oss15L8J9K+9K7VCJApqKI?= =?us-ascii?Q?sFYZ3fCews7asvSj/caLbAPljrO9NnJaOElfl21mNCx5y59/xhFijzNQMuaK?= =?us-ascii?Q?yaifyeOq0BG91AVcIhUNCvK7Rxd9Zcn7AtKjRl534x5CBIRyc8p9pNjvB1FQ?= =?us-ascii?Q?T/ffH6PMlEVRmhAfuDCBSGp/rItH6tgHEbcBGCWdOr3z56lc5xJNuTMZutnb?= =?us-ascii?Q?CgbI7i1ouk8MEJWoV08veSEZgI5+10u5L3ndK1t9jRwTOfbPUUfNvA9Fhc8C?= =?us-ascii?Q?LquSzCJKi/nWozw1xSUxwXp2OGLVlLkCgXs5c/ujcaMMVRPbQy1vUNF1Nx9U?= =?us-ascii?Q?s3U0lLbB4A686cIQDw+upxc/AayO1PC12P/klSaYLn62lmwSoY1TcREKIn1j?= =?us-ascii?Q?lnRyVFuxSSxblf2g6ldhE151OvvmcdyshaUurh7v8CdwJiLXLZG97JDtmfwZ?= =?us-ascii?Q?dXmHebKD89PfYTc1U8h0AmbwSJyuy0HY7ARq/xmGG2DjwgFqyO/tYOkMNP2y?= =?us-ascii?Q?sK0wLpx/TPCoXqwmzwICdU814e19CSVrsQT5VSgE+eF/vGtXaGPcr2tt2TgI?= =?us-ascii?Q?oT0ZbQlsJdfruOG69rtfS9pD7b7/Q9ljOYRiDni4PvxAlDKO+CbKWdAmDE6U?= =?us-ascii?Q?tXThpZd5I1BlNTL6OIklqVNDoxwmi4bSd03CIRCWCaVbYn4pFSYZL3c7El/T?= =?us-ascii?Q?DtgY2K43br1YhwkdAp1zM0+SN1LorAJaKWK4DStLagMnpISf9MuFy/rNDLZN?= =?us-ascii?Q?rwFCX2Lc+hntyUE8nvbfslxvWu0xiaALY9oFGADt0NW9IiH1CxL8ZGMRZRfG?= =?us-ascii?Q?NH0cSZa7dLQ785iIG17ejfR2Syto2zXiCHWZFlR30bQfh/0gJ/z64DhO6OUV?= =?us-ascii?Q?rKJNVMTT/xXlqefsFHcuFqpKm/pVWMd7lz2eJp6LObf3EPdUjzJTR5/2f2X+?= =?us-ascii?Q?iV1/Nxn1l6nWEeIpBk0QDKjhLq4cA8SUw9P8+t4MP5QppPp/wO3nKQ5i7G9q?= =?us-ascii?Q?W4u3QfnsipY0s8ILR/wqB4gBWC5+ncA9ngaIkwkD/d5zuwsguzQEg4zfXotP?= =?us-ascii?Q?pZo9BUq/pMiEzU/2R2wikqgDxuN7rXLQ/TnaJ0Jpjtso17KJfksAy7hkgOTA?= =?us-ascii?Q?BGhO58N2gQ6tIrXbM0NN3vZTCNIZN84m6ZixlH5mh/ghWH6FngGvlf9VkfJG?= =?us-ascii?Q?mRo95/9mZ7jUjMHC0u15cFmLTLeYGqZ7bPt6c0/TYVcLG/+/maQ3+jd0G1ZG?= =?us-ascii?Q?vYPnOxgpHzpl4m6qz8firScdeMA5NpNOkeXfhj7OCVBtO1P9+DbvgnclN4j6?= =?us-ascii?Q?cC6ARijwNxdTiFSqX0gfC5cZb9RoGjtu5L4Yf0b/FN?= X-Forefront-PRVS: 0334223192 X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; BN6PR03MB3089; 23:o7+JC860MyZxNqdVbDMQZ8hWitpFISf4dtBmNmPET?= =?us-ascii?Q?6BWTwELEqUATKsBnygJQn4ihO39RuNqgq5ZiIKrX+Rb6C7e853DBd+2syXbh?= =?us-ascii?Q?SdiGpfO6IS9+0T7Rhu3EtPNH6uf5R1ryLHlQ6c1IA4ihAltLPkpdAEz5OHrC?= =?us-ascii?Q?Q/u9+WOMwovMqv7jaOv5IorG9BMMitCdX1E9c2zl9ylySE1JCJ7+CMfdclEx?= =?us-ascii?Q?99Q9yniHC6Ta5iYxU5gEGmWwgYjdjUnFkO9egRlWVmkLLQvmfUbtJTRW6grz?= =?us-ascii?Q?TLaw04MfCfvfQL9nsOUdry9SBmU2psrjheycj+m2OfsAjx/YlfvXud6YE6M4?= =?us-ascii?Q?2OVYNKN0A70WeWi4G6DitSRgEd4Eky4ep0ol/cQss1VUqUmd1bCxETXOwgvk?= =?us-ascii?Q?+dbvPmh8b0wURzNmK8Xk1+480aFgT7Tw+M4yQoNxUlOXLhITb07CRggjW64g?= =?us-ascii?Q?8r5cs211EARr5vfhlu3a+LEyrMehFg/62P2dXqxmJJLPivvZ8D4hgDa3ma7q?= =?us-ascii?Q?U4ivRZCxAedlU99znoNHQ/5oYm1oGPtri5SOCy25Si71VXUOfeMUIv9Va3Tw?= =?us-ascii?Q?kKNgbYSvv8M7U5dHl6yOXIUxO+3XQMImAOvlKDMyTJm9/nsnDK9/nUqR8LGM?= =?us-ascii?Q?tguNJR8UlNL1VJMNFFDIrRBkUV3ZKfT5oeG428oLIZGwGS4YnYRihHUmzECX?= =?us-ascii?Q?IE47pP+rLpuJJoWRpRYRZf1IiEBPjV6fxgIiixm9idLz/yjCg/09MCRdBZSZ?= =?us-ascii?Q?MgN98LJuJD7Wmuz374mwzZRO87a3B31yAwAboiO9y//uxrnyBPa9z3/TbOPY?= =?us-ascii?Q?Ik5MeA8OQbdo9s/hCa/fRAPJ+tVLygyBMnM7Zzenpz04cSvSWeUSFLvWYwdF?= =?us-ascii?Q?KCsDY9QXQ6nZSbJMh5I5J9qbj28RRG9BZhXaE+pEiY7f2sHBSHQG4XLwWtcX?= =?us-ascii?Q?Fo+POdoQNIEJ76jcxzYBu5Oklnizfg8T3MG+gbmlpWJ0kRADmAJV3nTQ8xNc?= =?us-ascii?Q?hQR8MpM/mqse5TVN4/9D664Jtp7oB/IpuI3ZeWjgpXQ0qlUEWvCtnia05tPz?= =?us-ascii?Q?CJQduzqjJcrofEnLKKgSDXei37zYgkNym1FEImmZTpNvwYIsXbcVsNlEZMtM?= =?us-ascii?Q?/B7X6TF7LtY6opGoSBre3BaiZnSz29hq3OrRfWXnPiiOuHebJmTNK1c7Ickr?= =?us-ascii?Q?nUVW5qp0/wO60yIMlCso1kwOCtZWlOT4oNVTlRvzKZx4jNLDq80nI4zN8Lwg?= =?us-ascii?Q?gD53UEUklwjgPmmpJqYdc/OOWCky0Wf6U7ij3AG?= X-Microsoft-Exchange-Diagnostics: 1; BN6PR03MB3089; 6:j7H8timO6M8CuptpNTb0pR+Xd99/H1CXvDgNLzuLCchmxU/QH3m4yVPsEgMTqKQi8JNeMozrq66pfaCjr91DvMlsCB8jU1Z1JLfcTo+8bQn4VgumsYZa56y9LrDHh7dks0qFLp6w6sHe/Vb70yAQhWel4uGv1oFa29pgrWzhVpEFywT3UkpMzTvW+qZmin0NPIuWK8nykvEf2hIyE8oWnyN1kJGLLzP/G+jyD+yMco+hR9sBlYEcm1M73aQQJo7xs1e3Dj/tZyrd+q61dDkqT8TvgJ59rfe3/b9OoGkBDWvF2m5VJnNPN28hUhftFVMJO1Di7DXmPMW3RmqynKxpHjXQh5C2KSVY3mw3YPuatvfa15b5uc+3jVBXxpjhM1wEHdlshPWwzNrqQS/t8G+RRvYlejwUC8nikYfFWHsRxI0Bez80On9WZBkVNZvN0I0HNQw4eEJ20quGWVdw7YwPbBQ6RmBUmH5yy9hS+6Ei+1QKR3RbrHVg0cL7hJue3ndYNqEwAujQhX+yKR7IBjaPOO/T0jcWm8f16ScukCHqq/g= X-Microsoft-Exchange-Diagnostics: 1; BN6PR03MB3089; 5:OzBlHDoAOKU3tJpE+UrO0r594sxS9pAskGS8xIko+lWKFNSea3bgOAdK12g1Veu8921Tsik7TpVkzEPnjcMYi+y+xnzXY5jVCs+fAC4jdND7uuicBMIdJiSHQrTfzQHVDFZUMCqlMD9YAXO5Jq/HQDOglLxi3aRiTmcJuiCIinY26JsBU2lupgvQ4q0GpUA3ju+WS+P1shijSBEx61YH53fpvnxFY9V2EC3Zj0iNvPu+HgnAOL9GhdXSB4wWiPzRjcrBoJNk4qli30ubw5KaHll/C6AVUL4bksVBk+pQ7QskRdq/TIj7PS1gT8IgvzRrJAshFlRFEdMdjdNRYqzCDl8G56lTIWutwxHpT/+y+G+KRnoCnorgU7R/qQNKt/UT1m61ulvOk8tDniJKXsYPdQ9mJxMuy7J+lukJmE8fepUOsxAGFtlP5EjSjBNrED6b6qG72YsKU30tXwPtDpJMC6LKE03zkJ13yTg230g+Ak+BCOgcor8eXv24qCOrBrkX; 24:60V/R9GnEFu0DqJV5x1KtVFGC8Mke0WjypulSDMJcw1Lfbiz0TWduCpob+z2a7mcrxgMhfyRAFI/jdN5vA1GFponlOQ7evoXzwWefL9IypA= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1; BN6PR03MB3089; 7:EoRk6EgcvUvI+mnjdxAMvvnl0UbWTH9q9YXzfTnic1KWVN61vMfwnMM8Kts/arP5FQgh0phM0rHMyuYa6U5aYO8JrdCE1V12WjpGToMaO5epFQa7Y/kS+fkIX5Z0aM/XAOJgKPvtfSEpd52SYbnsrhf12aQAyXvFjoFtBMfHZYwYBFNYdxgT+riaccI7/USDKtdkDhgBTsOayW/D4BnnBLoyAp0aP/R5sRJ3jworCpFCRDqlvBzhPwZe4c/GPDuDyoYa0BImMQ/nESro4yVnB1DVHChvTpGPSaJ+KB+MMqaud/XZUQ3AVNImfRL2i7FQV6TFtikt2XEkP1zceo5X5w== X-OriginatorOrg: ca.weatherford.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 10 Jun 2017 16:26:00.5212 (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: BN6PR03MB3089 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.23 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: Sat, 10 Jun 2017 16:26:04 -0000 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 Int= el 540 SSDs. This is using a FreeBSD 10 amd64 stable kernel back from Jan = 2017. SSDs are basically 2 drives in a ZFS mirrored zpool. I'm using Post= greSQL 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 performance= 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 w= ork to find a kernel that the FreeBSD10 patch would both apply and compile = 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 and = test took ~80 seconds after which I rebooted and re-ran test and was still = 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-st= ats -a, gstat, et cetera): I'm hoping some enlightened individual will be a= ble to point me to a solution with only the above to go on. Cheers, Aaron 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.