From owner-freebsd-hackers@freebsd.org Tue Jun 13 18:48:00 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 316F7BFBDFB for ; Tue, 13 Jun 2017 18:48:00 +0000 (UTC) (envelope-from Aaron.Caza@ca.weatherford.com) Received: from NAM01-SN1-obe.outbound.protection.outlook.com (mail-sn1nam01on0065.outbound.protection.outlook.com [104.47.32.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 ACBD92A7F for ; Tue, 13 Jun 2017 18:47:59 +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=EM8YnyFUbJ2b54sEbid6XmF4zyEyHeqgum6myc11b7g=; b=QASJrYaFcxGtd2AhBf0qAefXmZXUz0iCuEQkN4Sjo1NJ4croNqX1DaPucmP2CpP4zipnOJHaMskyXxBLEq//F5XnM4JaSSoEt1z2Xnmd2KkoMF2ctesa33dTjN2iVw0CihdhsBnzhlXvx0v7AavPVtuJ2x/HHJVu2CIXPlAlkso= Received: from BN6PR03CA0062.namprd03.prod.outlook.com (10.173.137.24) by BN3PR0301MB1234.namprd03.prod.outlook.com (10.161.207.22) 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 18:47:57 +0000 Received: from BN1BFFO11FD042.protection.gbl (2a01:111:f400:7c10::1:136) by BN6PR03CA0062.outlook.office365.com (2603:10b6:404:4c::24) 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 18:47:57 +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 BN1BFFO11FD042.mail.protection.outlook.com (10.58.144.105) 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 18:47:57 +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.1157.12; Tue, 13 Jun 2017 18:47:56 +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 18:47:56 +0000 From: "Caza, Aaron" To: "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/716RidACSHS2AAAqINMA= Date: Tue, 13 Jun 2017 18:47:56 +0000 Message-ID: References: <79528bf7a85a47079756dc508130360b@DM2PR58MB013.032d.mgd.msft.net> In-Reply-To: Accept-Language: en-CA, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [141.251.205.133] x-ms-publictraffictype: Email X-MS-TrafficTypeDiagnostic: DM2PR58MB015:|BN3PR0301MB1234: X-MS-Office365-Filtering-Correlation-Id: 244e9ea7-986d-4828-ccf3-08d4b28cb55e Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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)(39850400002)(39450400003)(39840400002)(39860400002)(39410400002)(39400400002)(2980300002)(438002)(189002)(377454003)(60444003)(24454002)(13464003)(199003)(86362001)(24736003)(2900100001)(38730400002)(9686003)(66066001)(55016002)(110136004)(6246003)(6306002)(7736002)(356003)(305945005)(53546009)(47776003)(5640700003)(108616004)(53936002)(68736007)(97756001)(46406003)(2501003)(50466002)(2351001)(5890100001)(2906002)(6116002)(102836003)(3846002)(23726003)(50986999)(189998001)(33646002)(97736004)(5660300001)(8936002)(69596002)(106466001)(81156014)(7696004)(72206003)(6916009)(229853002)(966005)(22756006)(76176999)(8676002)(478600001)(54356999)(8746002)(42882006)(81166006)(86146001)(2950100002)(21314002); DIR:OUT; SFP:1101; SCL:1; SRVR:BN3PR0301MB1234; H:032-smtp-out.weatherford.com; FPR:; SPF:Pass; PTR:InfoDomainNonexistent; MX:1; A:0; LANG:en; X-Microsoft-Exchange-Diagnostics: 1; BN1BFFO11FD042; 1:VzsEmOBtRy9s8qJwoR9jhGvvPxFBoGJFsyw1rLoO2kHV9PrYCfRrxICdc+/gRMQrFV0cVWRYadO0maS1BY1mntIs4qkOE2OeDTOVUvw1MfpI3n9LUxn6DNApNkqWjAlo+dns6H+mes2002Q9djCEtG/hKuQ40H7DeAKmMxOiT6Z+21z+s/Ls/fKVXhj4GZMLcJjyjjQR5Gh+QoYLsJLIjKiePTTkNtV/teVojaCRjjL0U07gCYHZvXvrxCviKDW+eCE+0vz9aUcxQNfClBHoXvKbSKRdBmlo9y0KjFKNn+bk0RtSud8R3JUKTgwGW4qEWCNMHeY2dGIZzLVcQa18QB1LQMpZTgE3F5mai3UaWR61iVf0VV5EElJEkxDHrSGNFn9LSwTM65COi2rRTRx8fr7VndYJKVf7/90X9SVFPoGqMlH7MiMgCeYv4moJetkK0p6Ul7B5XtwkN7m1z5e52bRjyJwwnmLsj6WZE9FbtLABDQxvS9RY/1+eqab7/yd7sUvrs2lew79N5kKM5bgiGNJfy6aC1aLIOG3OSMAQqUo= X-CrossPremisesHeadersPromoted: BN1BFFO11FD042.protection.gbl X-CrossPremisesHeadersFiltered: BN1BFFO11FD042.protection.gbl X-Microsoft-Antispam: UriScan:; BCL:0; PCL:0; RULEID:(22001)(8251501002)(2017030254075)(201703131423075)(201703031133081); SRVR:BN3PR0301MB1234; X-Microsoft-Exchange-Diagnostics: 1; BN3PR0301MB1234; 3:V7DfPlW8Tli/22GYlpJXT7o8KXHT2lKbXPiJpuDh83fMNmmn3f9H/hiYNp0L5CRephCut+iVoZTXl4Y8KRR1HMgDPldV+9AxU2wTfXtSU4T/m8u0k/I5ssgK7LdvheKCxXA8HlmtmhdajroTMz/Qh2jVxWYXesSBwff5+nkY8ke6TWaBB77iU/hF9/7cdEsH2Om/EpVJ83mpqcUaoDRSfmbDmcmpJC+z5bGBfm3Q6Tmf3dwObiq7ihGD+rq9Tuk3TMzeYseWMU1CSJu7hYJnLJP7hvqEiws6cR/Kl6S6h/aSm1Mgxh79BN/LoSRBWvvZusV99TouU6JJ1GsAws/ZTDpwHgjgXbTCfd+CBptBj0EgnMz1RP15cm/rlR9F6f1/RI8pg1YCJJbJxm0qtnrlEAnSei9L+RHqi3s860vee3pR6FtcPFHUpzkl69Mmmzcv8gPXNqlr5JouejnH6C+/maIpJeR8dPbs/AV9wJ7gmNo= X-Microsoft-Exchange-Diagnostics: 1; BN3PR0301MB1234; 25:dt+JUOvpXw+7k74qsv8wD3EmXAS1uHgvnLVc4rJe21nL5dAxmQF1/ThAa2T4gA2LfKSF8soGR2dfee2XqKchwlIZOLPUNtIulQjh0gmNZJf72m913X4hzyFfkxp4Ok/bsk654S6aeetce4p3uIfeos91XidfTfhtRrFzXsoruR11tW5/Nh9wUb3rC21SKMlcv/QH1EQ0yQFm3iL5rayjTm5ePWhHqN7tQRvBNb9HQvMf90SSq3A5E+1+Wc21zCPn1+U9xcPpn9mpiuac8I/i2shQgZxqmVXmQDeh7DzUXmPcJ/ii42zE+R6ultX8yveGggv+plo8LWTbgwBx33D+dVBf7Qh5TxAvRQIPHwBDLQPw+sVMp8aH0cYZOwQizadM6aQnRLBo9uuf8R+oiafybIJpyCV7MxjlqufRH3eQf/LVY6dEa9gc1jWSfe9tM12WI1z8249OjZ5C5L6P4lIw1uht0J3jMo0oGfBlY4EhOFk=; 31:15itu96UAHUcvyZ1hCmMeOftGavW/fu17cRfuOb+CPM7/tZVG+0p4ht3B9JtlgniUO9KY8zZewcqD0wBCvt2WKO+DiAoI8lPKc9xZFWZ/4OaHTNRAWS2uylspk7vPv0blgJPtmcV2AVnkCmd2GABpQguDYtguaetfPujESnUb2MzDK89Im60JLMT8CVJneZMK17ty/pphnn9LbcC06/dar6KFw3KSuwTRLlVSkK4oEkAjBpck/QNNv2eK+36lDUOfGHYkl2txevIhyqX2MIlTFzJCoMQgYZZPlqQRm+AKUk= X-Microsoft-Exchange-Diagnostics: 1; BN3PR0301MB1234; 20:IO2tJa4FwFZtOgPXuBQBQ4kSSzYWY+hBzmIUmRMAOyXghWAOHb7vwZd7l4xkQfZ+8gERqlLkZXp/cHu4FqhX6qfOvUYfRv31K4rxZnnWRnQmGum3eFot/aH6oVJ+81cIhRQTNVdrimNjBNlrSyfqy/ZfZlJp4WBGL+OzB5kWCqg2XNP+nTjZfoLTsOrgi4QaOKnWR9uGy80p9gi8ehNzLDAMWCh8zeCjTUDHt4Ncmtol/guyUI2xoj3gABt5/zaFzcE2i8fBw0jGGp369nU7bR+1W7E9NTJSSnPLC15fjeE5wjal0Om6jZEXlgLPFq6wnWppEWh2luknFvgvmKtVEgVbW5LfXlfsQVwv0QLHoZprXqUBxY21VM3VrY+pA/X8PqE4Zssd91ssRmt/BalTVWozVcV7mb/Ireha6Yv5goGuMXs3NTRGBEnkF1XZ0BIgPzg0o7IrGAliwNFJwaEBYLkyydVJT8RDZcG6FdSfxK9NQLy4ohAJdQy63sZjXu/c X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:(158342451672863)(192374486261705)(75325880899374)(17755550239193); X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(11241501159)(6040450)(601004)(2401047)(5005006)(13016025)(8121501046)(13018025)(10201501046)(3002001)(100000703101)(100105400095)(93006095)(93004095)(6055026)(6041248)(20161123560025)(20161123555025)(20161123562025)(20161123558100)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123564025)(6072148)(100000704101)(100105200095)(100000705101)(100105500095); SRVR:BN3PR0301MB1234; BCL:0; PCL:0; RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095); SRVR:BN3PR0301MB1234; X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; BN3PR0301MB1234; 4:BMBWy91SsZMrTdL3e/54920gLu9fcuXUWAQ1RR2P?= =?us-ascii?Q?1yTwyGci5kbF50O0CmUOL4yqDkmYvOpbb8JeFEQobhQXIUEFpJh90lxHaxoV?= =?us-ascii?Q?hPiggV93EUgnYJD7auXoxLkK/JD25yj2oWCmisR309Qs0++pFFqzpPwipwLv?= =?us-ascii?Q?pNQIyW8pZdS9H8FzbdeoXlg7jxPcHU88HJ7tkoMYlcLV8Icc0GoSK9AVo6C3?= =?us-ascii?Q?1Ymyywd8UbH5zHG5KDb/2HAEfs3W4Xry62iCA3h3p3S8KnlIHu98zhr3oQQX?= =?us-ascii?Q?O7wByOJsNKCaIxKe5Of0qu3v5P3jXooe8KBukZs4cxncxjkw1dFjM0RSDU7A?= =?us-ascii?Q?G0uYpwNrTRljYfZDMxQkXGJktyC+WCZUXAOkofU77K7u0/+cu06jWpxLC9/L?= =?us-ascii?Q?DmhO5Y+7xLtQfH7vNdouantz2yNwBQf4ZFzm+1Ie9bVDX3Xw6xYMi6GFf8iD?= =?us-ascii?Q?H436Fm2wy2s6vITVWbut+byL5vxFQQRKS6itzmiRnVAxb+9DkvAYGJPc1K+Z?= =?us-ascii?Q?1oVTcTQgOMdi7Lznbz+R4r3aA7EgIneNmvAzeSy+IL9J7U5lLLc8XfqZz2Ms?= =?us-ascii?Q?LDRI4c+Dxy19BaA/ui2uvEhF9fUWN3d1gQe+3gVSpf0bsSnAmDSA6inGRJ8e?= =?us-ascii?Q?o/w1fsSgympbvSMam7TvNRa/vb3x4uFEn3hRw/a14TMFRF96Af9tum0RJtyy?= =?us-ascii?Q?FWrndBPYVxTRKbjSHlCPTSlKk9w6TPck4zo2QzXl2Ym12ANZrtmW4TPFmieI?= =?us-ascii?Q?HkhOF26l8sifyEqyfDYuwBpFcGXKyyS4mYBLIwzvHUx/DzJ12TgfE8dA+Vd1?= =?us-ascii?Q?5LV8zLVt0IEemNnzBPsfS3mlKiPNrDNcLRe36ABhJI3nxkOVww9LYcBE/5B0?= =?us-ascii?Q?DtVNb1alGhjDfxA2wroEQ0ogKZKJ7HmzNRr6OPkPKLzfDQayLVqBVvdAAXEM?= =?us-ascii?Q?RvnAzsMGib01OCkMypJJwYjF++Xluqj+up/HOyjim4gbL3hp2UTrcpMDDHzS?= =?us-ascii?Q?UHHoKgWkjpC1u/rhvd7rGKe1D573xJy4fTYTJ0wEaXM7I09H4gV0ky7WYbbd?= =?us-ascii?Q?scbqgcvEMurtSnr4PHSj8jIKh2YoTuaeFQ8Fk2SgrT+klpjPfLe1WpSMgbMb?= =?us-ascii?Q?U2+oAMKxE1yc1MY1i0xDaaQDD/msHo0uSXh0d669sNJKyCWLKoSNum0klVOL?= =?us-ascii?Q?Uxqkaz1ssOGkThPafYejYZuH2HQrGCT4itM+0kVWOf5/j5zf9XtEH+wfkXsM?= =?us-ascii?Q?Ptam2rTpOlm5y50lQ49rEb8sBNSZmCgHr4GwJXnNjpiMno5imjy47LAwiws2?= =?us-ascii?Q?9LhaMG6Xt9hLWq41k/B2yqyQrCjaypYBB1keIHOdnh6HLV5Cmd90WGLAOkm5?= =?us-ascii?Q?ozgI0wFotuiWylglNOlH9TIi24A=3D?= X-Forefront-PRVS: 0337AFFE9A X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; BN3PR0301MB1234; 23:/HIGmTXugiLNbc1m42bHb86Cy6xQgfxLp4Ng54j?= =?us-ascii?Q?qDIGRYzmR6PgzYM/8KzCNeyIlD2c+s0VpxxxWVrU+G7u6dOh1ecQeadOFC3R?= =?us-ascii?Q?rAbyxwr+dnW/+HwU59eheBOvJf0xq0ZKfJDNrllwtgY9Q9aO0ZTZ3rt1E+NK?= =?us-ascii?Q?/oGvYEO2Em6uv2ILF1nyrZEs2AsxRnvxGkOc+rrfzLkFuu+wJyoPzKoRewiI?= =?us-ascii?Q?I7o0775hnolhKzSzC17J2zpBc6Or3IOnmobjXb4cCPJqSRoa7WradWfZojD8?= =?us-ascii?Q?J37hQHGMGTGZeClzgVcAVPIKDEYAywBcU/GIKqympGLEerVSfdhO+Qqb9/gJ?= =?us-ascii?Q?sAi74xvsaSYf410/WMebDzPP493knFbpjaMviaJWl4NdcFokj21nwJvxCRdV?= =?us-ascii?Q?QlYqYX9PBF20bmJzMdnpKr3meSO6cAqj9C/oCVwt3ixU5ULgXn4yGNLznVUM?= =?us-ascii?Q?SjCkrt/b0MCjY3TPE4jjrG/OlCY2rfBxmXmrKqkw2uE1rIMnzWDqhaN1BhCu?= =?us-ascii?Q?S4qL3QeDe2nSYKG9VBPzw+W2Vaz/0gH0vOcrx5haoH58tSuro88KiCDSTYAq?= =?us-ascii?Q?dLFKJ3qqQof7DNS7cZvE54YXA1JmmIma52FdC6hJMMHEaS+Is8eEFPdCJqXO?= =?us-ascii?Q?cOooSPXvUjMsdLbrIEAlBfTxQKeo9XXrxnqmMQ7DzyGUolK8ig3tFPrFWyjl?= =?us-ascii?Q?cJirlk2C9rhI60dHo0waBWps7UzIWSiDEYy4w06fmmgbeo3WVa5sYaZQ+MkF?= =?us-ascii?Q?mRNNqGmY3rRceFG9UziLW9Kn+i6eC38ZfT1ev3RXdwF+zLyxQtreugtdvt6h?= =?us-ascii?Q?Qi9HHblVK0LCpXpBmZz/snyUpWHIY+/x8W4C+2w7p1pegLoLTPsqvJ+6yuac?= =?us-ascii?Q?a6aLfHR9wSgovwOrg5Z0k88nhPHIQeXgZkfYsDQscKtDVNgt/8u7xavhJEBW?= =?us-ascii?Q?LOqyDcVfBw1rYfyHQsCC0x2AYpbr5g+DeK/EuOJ76NIdCCTO3TfY0vYCiwUm?= =?us-ascii?Q?vIiswXRh9bP71FNn9e2dUi+vSh9PlJu9BMDuPwK5dybJ4L4fGqSlq9UvTEq/?= =?us-ascii?Q?2VJ1AWCG/4sjBAdUlBSfeRDBtYSR9nr48FEj1S7WLgqcFKP8f/pvqHDLDnSa?= =?us-ascii?Q?COEN/gjIR4jJV0lBwQPCG1Ey3gHWNHgh2KYPDX1/iIQ6AWIbeeGR4W/ZapJh?= =?us-ascii?Q?RfQqZTo16fNnC3zGiQbdZHU2sAKSrKLZDmrDFM4UjV2wNM60aoo0qnmBavtZ?= =?us-ascii?Q?E0D6BW/uNGj2usYPmWbP1K/JBolN2zuIPlDlaQvd4t7CeUVtv5OvpxcGC2vF?= =?us-ascii?Q?SVdaOIho8Jgd66vZGYxELt556zAzwLDfbuX569vpV+rH8jsrfxBLBP/gtXp3?= =?us-ascii?Q?kCuKiYoxbO2LwLO3q3o1wcm7YYTM629HHwrtbpCh0up0xc8JBt5WFqtFZtJV?= =?us-ascii?Q?OIgH9gxJkuJfXLatEh2I/V/4ckudE51wxP5xed8My03Ah3RbKKmHRXvTyXyD?= =?us-ascii?Q?6GG8EcFbVagQFYC1x4j6T7k0suPFGHppJVAIUSXhQK7gbSnkmimFytYC3BAB?= =?us-ascii?Q?cHuNniTYLEUPXdFoVI5UaTM9A8OAY3pFi5eUEvzG0u2aF/bRyAyuv4JfM59D?= =?us-ascii?Q?tJccyQ1wLUBeX8wO/AnRQ6Itq2mdK6i92rdlc2lyaXC8=3D?= X-Microsoft-Exchange-Diagnostics: 1; BN3PR0301MB1234; 6:7/H4Pu/6tqkPpoabhKW0UhB1H2AbqJvo6TXj02S5VAdX95dXRxjoNt3iZyz07B15TJBqzRIFWItkKyJUQTsTl0jWMn1p6BhOehuys/E4TZrAgdPf7xQzxJoLnfPQjW3/ifoRFy5EvfLtb0Aq2YSK1xvoiyFtvtuPBXcNehQn0vthi12OK8SFXrW/hUzkBdBZYkoTCRD/o+XXk8EpE5KAayhw7qWiP+PbGl4bSHpGYD0OpaObupAYeD8y+1d5CfMWJSTcfbPOSI8/gGMyXd00gkFyWJL+msgNsADM0vWcL79u1Eg9UiIyOABbVqj72tVhcMSxmz3RWz0n3bUKnYYS/x94Q/DMBp7StF5sPx96pOJxcudliaiad++ndoJmF+ynaLTskoAzOPba0+2DOkYF/GYetsxD8pLzUWPAPLbDuA3mzpLmM2RUOguX1g89Z0d91ej2UFVE3k4HFzuatoIL6cCzbLCjSn01+1cVhawi/D35ppKmrCK5iCOu7k/GehPCXlRfgPFdemzjQPOd5AejiFRreiM87qzniYNVcitEbo8= X-Microsoft-Exchange-Diagnostics: 1; BN3PR0301MB1234; 5:A/WS80EuhEJhouQaj5k5kdNTeBlhgfhmvLybXBgpK8oWpe+iPS3hDgu8TBB9wk1Vwc1C6z2Mejf/mLu5ZXbvmGGmlrpfWmJc40gVhEZSJtxQEEErdloBiqe7vfmk3YX7iXiZ4RIVvIjN0RfhWID3g4HzWga/XWBeQ1qt6s/Nj/zls0iL7+TPdWQnnKcgD0mssf+zPs7XNJzK85Y+gU9YfiqYs03Gf+mp82ED8H6qfutXA2Ki+jB/0CJ0ti+zoRZyy3X2tHxKCSl4CPQGzVRgqPDwOR06TSACuG1ROT9BCLJ2wDYZe13Od2a5v/wf8Ib6/yvpWTclj3qspd21y3lXVhg9qGqJjMVO9U7YXmmpuqC9rtHcd06VwM5/DNtwfLYfPUv7y4tjf46pJV5ILCqdvlTb+cEJLRzxzmZOODk1RW/mFgEmoFkdBabwBYddCQ7f0zq2YLu0JIRPo4G7XSCDHzKmA1kIYVS9myb3kJ/cfn8ov07CFBmWVeoBRNnvb9rv; 24:0sk7aHoR5ghBj2XS0dPWIQBtFDsTS6jLpE4LqmEcjwDqEp4AffRk1KtJXL0S5i0O4AmJNOLu+DV1wHMbkSr4d5gM3lBjJ7AfT8bDS1PMULc= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1; BN3PR0301MB1234; 7:chHmQT9F9c4DhLFJH6WaMkDE81UUqxYfW3PNHfcPRFR4Efxu6+ddNKOHhVVLfTTuA8+PVlZojdZVxArcU8gAUoBn1rTUfOTKXUzTSx75ev7QKhwiP1JSxKCYC3VtGLvF4fT5nUbArIiGe+h4V3vZGL6rgnMdlhZKkcoC6lFdMCKmIWKdpNWe2E1LBorheSOmpwc1++XzMNhf0J8r4d/1vnJ+PUeA8P0+YqtnfadOLmzu3SgMfRw+Sl+VEuZS0HKSFkeEdTZPWwhL/oCZGw2o7GKECMztlK+3kYF1PvTQ/d9MYLpXHtIe0vjzSLzSsLqh5R1h/gTJJ6NGrueHSFA73w== X-OriginatorOrg: ca.weatherford.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 13 Jun 2017 18:47:57.3357 (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: BN3PR0301MB1234 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 18:48:00 -0000 In response to the below, all the MB models I'm currently testing on are di= fferent. Thanks for sharing your results - you're running the FreeBSD10.3-RELEASE-p7= kernel back from Aug 2016. All the 10.3 kernels I've tested with so far a= re stable/10 from Jan 2017 or later so I might have to try going back earli= er. Currently trying a checkout of base/releng/10.3. Unfortunately, it so= metimes takes a while before the degradation hits which slows down testing.= Also testing a stable/11 r307264 per prior suggestion from Slawa. -----Original Message----- From: owner-freebsd-hackers@freebsd.org [mailto:owner-freebsd-hackers@freeb= sd.org] On Behalf Of trafdev via freebsd-hackers Sent: Tuesday, June 13, 2017 7:37 AM To: freebsd-hackers@freebsd.org Subject: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performan= ce drop < 24 hours > Tested on half a dozen machines with different models of SSDs Do they all share same MB models? I have a similar setup (OVH Enterprise SP-128-S dedicated server with 128GB= RAM, 480GB SSD in ZFS mirror and an original manually installed FreeBSD 10= .3 image): robert@sqldb:~ % uname -a FreeBSD xxx.xxx.xxx 10.3-RELEASE-p7 FreeBSD 10.3-RELEASE-p7 #0: Thu Aug 11 18:38:15 UTC 2016 root@amd64-builder.daemonology.net:/usr/obj/usr/src/sys/GENERIC amd64 robert@sqldb:~ % uptime 6:27AM up 95 days, 9:41, 1 user, load averages: 3.29, 4.26, 5.28 zfs partition created with: zfs create -o recordsize=3D128k -o primarycache=3Dall zroot/ara/sqldb/pgsql custom param in sysctl.conf: vfs.zfs.metaslab.lba_weighting_enabled=3D0 robert@sqldb:~ % sudo dd if=3D/dev/urandom of=3D/ara/sqldb/pgsql/test.bin b= s=3D1M count=3D16000 16000+0 records in 16000+0 records out 16777216000 bytes transferred in 283.185773 secs (59244558 bytes/sec) robert@sqldb:~ % dd if=3D/ara/sqldb/pgsql/test.bin of=3D/dev/null bs=3D1m 16000+0 records in 16000+0 records out 16777216000 bytes transferred in 33.517116 secs (500556670 bytes/sec) robert@sqldb:~ % sudo diskinfo -c -t -v ada0 ada0 512 # sectorsize 480103981056 # mediasize in bytes (447G) 937703088 # mediasize in sectors 4096 # stripesize 0 # stripeoffset 930261 # Cylinders according to firmware. 16 # Heads according to firmware. 63 # Sectors according to firmware. PHWA629405UP480FGN # Disk ident. I/O command overhead: time to read 10MB block 0.285341 sec =3D 0.014 msec/sector time to read 20480 sectors 2.641372 sec =3D 0.129 msec/sector calculated command overhead =3D 0.115 msec/sector Seek times: Full stroke: 250 iter in 0.016943 sec =3D 0.068 msec Half stroke: 250 iter in 0.016189 sec =3D 0.065 msec Quarter stroke: 500 iter in 0.022226 sec =3D 0.044 msec Short forward: 400 iter in 0.018208 sec =3D 0.046 msec Short backward: 400 iter in 0.019637 sec =3D 0.049 msec Seq outer: 2048 iter in 0.066197 sec =3D 0.032 msec Seq inner: 2048 iter in 0.054291 sec =3D 0.027 msec Transfer rates: outside: 102400 kbytes in 0.671285 sec =3D 152543 kbytes/sec middle: 102400 kbytes in 0.640391 sec =3D 159902 kbytes/sec inside: 102400 kbytes in 0.328650 sec =3D 311578 kbytes/sec On 06/10/17 09:25, 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. > > Cheers, > Aaron > This message may contain confidential and privileged information. If=20 > it has been sent to you in error, please reply to advise the sender of=20 > the error and then immediately delete it. If you are not the intended=20 > recipient, do not read, copy, disclose or otherwise use this message.=20 > The sender disclaims any liability for such unauthorized use. PLEASE=20 > NOTE that all incoming e-mails sent to Weatherford e-mail accounts=20 > will be archived and may be scanned by us and/or by external service=20 > providers to detect and prevent threats to our systems, investigate=20 > illegal or inappropriate behavior, and/or eliminate unsolicited=20 > promotional e-mails (spam). This process could result in deletion of a=20 > legitimate e-mail before it is read by its intended recipient at our=20 > organization. Moreover, based on the scanning results, the full text=20 > of e-mails and attachments may be made available to Weatherford=20 > security and other personnel for review and appropriate action. If you=20 > have any concerns about this proces s, > please contact us at dataprivacy@weatherford.com. > _______________________________________________ > freebsd-hackers@freebsd.org mailing list=20 > https://lists.freebsd.org/mailman/listinfo/freebsd-hackers > To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.org= " > _______________________________________________ freebsd-hackers@freebsd.org mailing list https://lists.freebsd.org/mailman/= listinfo/freebsd-hackers To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.org"