From owner-freebsd-hackers@freebsd.org Tue Jun 13 18:51:35 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 2A9AABFC109 for ; Tue, 13 Jun 2017 18:51:35 +0000 (UTC) (envelope-from Aaron.Caza@ca.weatherford.com) Received: from NAM03-BY2-obe.outbound.protection.outlook.com (mail-by2nam03on0073.outbound.protection.outlook.com [104.47.42.73]) (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 AD1DC3119 for ; Tue, 13 Jun 2017 18:51:33 +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=U74AtwvIh3h804F6gdetFSb23pHm3f58EsiX+MxKFFc=; b=fLepUfMujMhCzvKXX+3pnSw6LSUruNpRLlX0EBENas3fE5FCnNsjYv8yvEBCoiTrJdC3rcePMrIsVhVDY+ANc7di+6BdTjlUM1qOXsu17YGZA9WmJZirWXzEoGaAVTvMUntEW90GOkVWFH2829RBNgrkU7pSX6/67yKj6EIjSj0= Received: from CY4PR03CA0081.namprd03.prod.outlook.com (10.171.242.150) by SN2PR03MB045.namprd03.prod.outlook.com (10.255.175.145) 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:51:32 +0000 Received: from BL2FFO11OLC005.protection.gbl (2a01:111:f400:7c09::171) by CY4PR03CA0081.outlook.office365.com (2603:10b6:910:4d::22) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1178.14 via Frontend Transport; Tue, 13 Jun 2017 18:51:31 +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 BL2FFO11OLC005.mail.protection.outlook.com (10.173.160.91) 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:51:31 +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 18:51:30 +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:51:30 +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: AdLi0u6ENydglNrDQ4GNB7pMA3LengAOo8uAAAioTWAAUPRVgAAAaP7w Date: Tue, 13 Jun 2017 18:51:30 +0000 Message-ID: <12e95f4e7e814093b1e877d722316ae0@DM2PR58MB013.032d.mgd.msft.net> References: <4410c303314a4d11832a8d248e0b53e1@DM2PR58MB013.032d.mgd.msft.net> <20170613203615.ae6df0a1c94bffe1dc6745fc@yahoo.es> In-Reply-To: <20170613203615.ae6df0a1c94bffe1dc6745fc@yahoo.es> 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: DM2PR58MB014:|SN2PR03MB045: X-MS-Office365-Filtering-Correlation-Id: 0e27fb74-88cf-4592-cd55-08d4b28d3548 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)(39450400003)(39840400002)(39410400002)(39860400002)(39850400002)(39400400002)(2980300002)(438002)(13464003)(189002)(24454002)(377454003)(199003)(2906002)(97756001)(305945005)(2501003)(66066001)(108616004)(47776003)(229853002)(24736003)(5890100001)(69596002)(86146001)(33646002)(68736007)(22756006)(106466001)(86362001)(7736002)(2351001)(97736004)(53936002)(2900100001)(6246003)(53546009)(110136004)(38730400002)(55016002)(6306002)(5640700003)(5660300001)(9686003)(189998001)(2950100002)(93886004)(72206003)(966005)(6916009)(42882006)(356003)(7696004)(50466002)(478600001)(46406003)(8746002)(50986999)(8936002)(81156014)(54356999)(76176999)(23726003)(8676002)(102836003)(3846002)(6116002)(81166006)(551934003); DIR:OUT; SFP:1101; SCL:1; SRVR:SN2PR03MB045; H:032-smtp-out.weatherford.com; FPR:; SPF:Pass; PTR:InfoDomainNonexistent; MX:1; A:0; LANG:en; X-Microsoft-Exchange-Diagnostics: 1; BL2FFO11OLC005; 1:eytmsH7zyEot1nkqx+CPEyLku4bBnAGVH6GLKFW3O52oOcaY3AF9IIjbLipMpiuD7joHAjQfbt5s1Cl2WzvlmXr8JuEKOV81n2gKivhm1Jcydjx2CgXvcMdYsBpQxKuCK8pxCdFVJedc2zMcoRVMYVBfLhGC12ujnnrDkWlZJoGEz6f1I9JYsNp27HJz274tOQg49aF4H92YVhwSvpHAxqZapqc69MotYJ81Q+x1g/KSXodCM3ut1CkBw4xNXDtbuvMdBUdNJdjeHvOsHnmsiknnTZd1ctrVfBPXRG0fSVGyiniofIQJAVkcpnqLVloOXXSadvEXgO1e+E3s+wOyVpKkxOCd6Ff37iBz+Q8rJlDf+NOtTyi4oEL5yYXKcYaSPURb14w1ZvJhqaqWt/IXOpb8fwXTASpQWlNmsxRGmcJDjN1DZsbhnrTCbKChLukKQGiOJ9S7JgmOMVE+AwHDAMmuBPNS2qnZDhTATYNJaSXJHQOAVNGwfQNjyscRcbjjs9rvJ73CWe7PRYk5QdGwiUBZi7wKRRu4fbPaYcjOO6U= X-CrossPremisesHeadersPromoted: BL2FFO11OLC005.protection.gbl X-CrossPremisesHeadersFiltered: BL2FFO11OLC005.protection.gbl X-Microsoft-Antispam: UriScan:; BCL:0; PCL:0; RULEID:(22001)(8251501002)(2017030254075)(201703131423075)(201703031133081)(201702281549075); SRVR:SN2PR03MB045; X-Microsoft-Exchange-Diagnostics: 1; SN2PR03MB045; 3:vM+og5kiMHah38ofoZAuvTiBKjM8SBNHq2zaNLq9+E6PMNHrmbysLilQ1J6srXDMGqaRsRaCrmgkoIMcu5PpYdSG1XUSPNVDzO/jqxPtWRTBDM/kl4ijrueMe26YV2CSi6mFdd2oF8KzSMM+hBOuiA6cASHf75I5MVByAYEmPca38r3qDy9lRf3C1UB//8p4K9JjPVJmH3WoiQ1Oe6T4Wo+s/fiGMX2pqDrYueFRU5S0VheLmT1Yvyafbj6pZLn06QBJNXBtUfZgis+6XQcNUv2a/rqYGPuAD45sF6EcJWVeP0/c4DZSeExdNKHQWR+saaiP0W0uY/ciaefdXmA14EfvfV86xQCNOinEWndJ6un/RTcCbSXCtGi/2EKaRuP5RbsYlk6hB+N2kqKnl+gsgUDDy2WNRKAsRwnjvM//Rud+Y7lTkwIbanvTFfx7WQiReLEtNLSwNKnL6IRbPzK3uc1n5L5p+qHq/wrNCf9jxlGbd81FoLeJc1fDm+InFuY4/NPaCNIg4x8NaCXREJM1og== X-Microsoft-Exchange-Diagnostics: 1; SN2PR03MB045; 25:X+WXtxzPe74xIbjAGVNFAjRmiDg2KBPaZmBh0oG1qavQHCAPI4/mxay3Wi0r6bFxHFu4n0kEK9odYoUELIZJQ7pqlGy6UpqcYw9bETzGLowBvPYYgknoB4ZjRqM+Z41Ege2V990+bJgn9PIvQl+PBNVBTjUwFaSFDnf8CZGpS80X6CFxmGnpMdVX3y+P4jOeciIcTEHOsxdxcjLn3GTB5A2Xz3GuGEkeH5A/K42y8n+xHWRHbQ9Klqn+tIPVavhMWCToI74Jo1x8hFwuY4Bh+/TGMBbtErRTmXO6cTjFi5GiHwOA8DtaeygjLWhvCONa/HMSqKuICb6wWp9vpckO5Brzbz1pXH74hp4WPxO0KphCjAmlWy8WfxLAznkmchlSjGUwIpCj7FND2ojNC4+FUkF4RzMwbww+T1m1X2ZCv3qvFREaOY4VYnWZ/g9kaJvw3CBMr4DMvuSonLLcZ4h45vTeodGL67sAYqlZUGpMhz8=; 31:xlJXE5z9PePryPj4BNVk+OgvTEpxYEIL1pMgFJCGkUquGJgKHUrftWff4U0/AfTSzEsRvt/Y1t+EEZE78HX7oW9H0ENNHlXTn9cOwQa6orYsh3xhDSaeodWBGYRVAmp5f4mRwy28yVMH/M+U/oxq2CCHRezDOKv4WPy4TQKtljpf2QIy8kXBI7e5jT87rHqAFP+pqBbTCaY6FERmnwtasO98qkjzlqWyV0Z+1tXoR6FSSFimHQRLMCVdPV6bPNU+68fQZZihoRtFfp5piiwzjQ== X-Microsoft-Exchange-Diagnostics: 1; SN2PR03MB045; 20:b2Crprij1JXo+4mGdzLw78YC62/aXGD/MlTdrzAnVNGtzVs2TbwRy4W0Y4lo25oDXTeU3f3xefUD+/tDIKLChUh8mpJRgHAAWXvHnwdSeNLTDLviSMRmeOFdiT0VBlgMW/n9Zr3608D0pPHW3QABs2antZrV88hWNFnnyCtOwr6P82XR9cG7BD6b/IpIePcRxUFMUP1zVNsYtv1UiyxFd0L54bNObeRjYhMcNc2i8pLZWYuVzWH8+u3budozmA8R3WKlqHWnfoYG8TqzDiOzuxQQGr+uIUv6T64IX3a1Qosk9ga7hOGaeLutnjUf45VVgIWOSJF0LSjGLFRN/zKZbIGTcPJa2rr3XpjdXYzTCmnn+wIJpXNirCSCVuP8g0F23YkJoqIXFoB38xyAuVm7Y6siFAy3UMl5pEgHUgtkAgQoEFajH9xXi3jnqUxUK/egY95boF+Fgt1dbxmLa93UecXc98t97ctZGbZ1xt+05MXKbhhmUTnjrAkt/XJJ4Jyp X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:(84480959824636)(192374486261705)(75325880899374); X-Exchange-Antispam-Report-CFA-Test: BCL:0; PCL:0; RULEID:(100000700101)(100105000095)(100000701101)(100105300095)(100000702101)(100105100095)(11241501159)(6040450)(601004)(2401047)(8121501046)(5005006)(13016025)(13018025)(10201501046)(3002001)(100000703101)(100105400095)(93006095)(93004095)(6055026)(6041248)(20161123555025)(20161123562025)(20161123560025)(20161123564025)(20161123558100)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(6072148)(100000704101)(100105200095)(100000705101)(100105500095); SRVR:SN2PR03MB045; BCL:0; PCL:0; RULEID:(100000800101)(100110000095)(100000801101)(100110300095)(100000802101)(100110100095)(100000803101)(100110400095)(100000804101)(100110200095)(100000805101)(100110500095); SRVR:SN2PR03MB045; X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; SN2PR03MB045; 4:SHG34wifH9brYJjaCtwjRmsTs73LYjMay4jFjAB2/tW?= =?us-ascii?Q?H7v3LcGI1cqJqOzVXQoYnypB/LD8ZHHqY/OocnnK9yXWgwMVRdnEpdB1I7RX?= =?us-ascii?Q?Q/0cB9pSzAbcTqBMLbxN7to29Aq1FwqU6t9YnRDPd7+umBkpVZibUbDPt8r6?= =?us-ascii?Q?313CW9Y8jqqKd2uHtbg7fU2a3uaiECLedy23URRBJg3rKuBjtn19hOlwXASg?= =?us-ascii?Q?pbIdb6ZFwc1A3OhlIw+3e3GhBJ4dFxu4ZIvIunGI6FnWx1fQgLZDOjW/jeBS?= =?us-ascii?Q?b49se++1Vg0xgQFwDsbJzhu81X+oYpt24w2Se79p/yx1y9h7qqdbfb7Pz6pB?= =?us-ascii?Q?Kz3pu4cmuDweeDdu6wxCUpt3OvoCUi4m9udmKiJlnNSbjyM3QG8NewyfX73f?= =?us-ascii?Q?GvxIKUQINjjY2wikGQWFkJuMzYLykL+5UoJ4054FF8QutdnjvlF+8W9gDMkA?= =?us-ascii?Q?LP/gfphEHAFsHBy4tZGIfh6B+uK9PechqGEzMkk3lGbyFCnkjJf+EFWxkRwQ?= =?us-ascii?Q?wE8FaKa3F45uuSx8sajYGhutlN20WPqnDOKVEq6ZSKfv51Ulc5Sm3P9dHN5Z?= =?us-ascii?Q?4G7IAnGCf4K564+1DIrHYXhC2Tmk2itH8JjoO6haenLoP9DXXp+N4ACWlsa6?= =?us-ascii?Q?RFfOXBuufQpxNwLdkNjPxhapDb9ZVUjk4VJIayNBeXZI2fDGFG+jL0jLzCtb?= =?us-ascii?Q?ZmxWeVRa0anV2sKAGMbosMUPFwsVaut+sfGrL0fQKzFXJ2ms5GMGj06EdYiP?= =?us-ascii?Q?UhtXVL2apXqLhcGUT4G9AE9JkX7I58fr88alQe3ZRVGJe43Gd5p94lh6lB5b?= =?us-ascii?Q?v/aIJrdB0VtK4ojFGv8dPNR0PXK3lWUmgWL64wNATN/M3Pkow83ZOjcQJhhf?= =?us-ascii?Q?dz2hQBK8mCJPnPVGPOrYH2fx3FGGGduHQHmcR3ocHnV5lKwU2ypUxiNsF+V6?= =?us-ascii?Q?oIVJZyFh8tvr1IoFj5Wl8e47IiAqnCnejXJUyvwzVYQHGKuYFUHIpm0TKD0N?= =?us-ascii?Q?EPqf9jYHbtgLEnmgY2v2yoyS/8GtARYISqVmpEBwbIbQvK/JKTDa05a/oqMd?= =?us-ascii?Q?9ko32hga3SPr5Rk8V9u6/KCaLRMknfrO3FrQ/9nLU5RJrIPajQ7GELxIAD2U?= =?us-ascii?Q?sJ2Ymdv/yJBdc+d4rPyrV/qg/JgP3Xkpulns5/pdoWfKXkUR/vmcmXsUtAhd?= =?us-ascii?Q?RR7AOCqE5OArTFsYQ8Se4yWOqfY1uecx4IbHfgF9SYh4fHO3sA2L/w1IGVOV?= =?us-ascii?Q?8Hgx6xl72hgvbMjzWaJlbeoeAOgbmGZ2rQlINudQ3OTWCMZA1yWQfCh0Ucbw?= =?us-ascii?Q?qPtEaQWlZhtLRqbASyL6Ktd3cqXYxnst4B60xIA/L?= X-Forefront-PRVS: 0337AFFE9A X-Microsoft-Exchange-Diagnostics: =?us-ascii?Q?1; SN2PR03MB045; 23:9qJvKgCA+LguJ5F+4ddzokY8i8AdH9egOifnh4v5bb?= =?us-ascii?Q?3JQrfL9oOhCj/ioTfvqV0obh6Xmsg9p8PcyIKtADSfarDB+xG0rOXOR/z3UC?= =?us-ascii?Q?2yQ8vHNkuFLL80+U2A1K/jbyEbFRIP5r13GrdyMznmZHivKh5mX+Mzn1PJqu?= =?us-ascii?Q?s2ZUVLDn9RHR5GPTfDofT1cH0j3lag4v1HvhhQFq9Zt3lUpJ74RwCNUYWI9C?= =?us-ascii?Q?qeHDd7sfoxp5k5jvyOwIvtbGABAOXDB9UqD51JboUEbL9AGxZIZnPRO0ZQqb?= =?us-ascii?Q?eaCM05YiVGHqPwLsOzgyXrP5T6MMU7ql+8/VXN130nxocH97nrOx9Q4d5V2d?= =?us-ascii?Q?74CNq9XLSx1ee3vmVp2t/1q96H9r4otpvViIKRHD1I/qgMU+KfCxBO7MPAZ3?= =?us-ascii?Q?ojg0xuGx3vzTVp6HVxoqrCRXj36/ODQeOH7SJnK6sQuSAdUID7bp0y/ASgza?= =?us-ascii?Q?OQIGoVSAv0WvhuIOrhTauVyI9BaTyXIql+jcZ+l5StyqjT662VACRQCfTk32?= =?us-ascii?Q?k6Mlzog0Ha/9AwT7E8VPtT9moNn5GsUyW6oVdtZAkn2wBmacy10XVBxncDKG?= =?us-ascii?Q?rg9eznu56VaNR/3W8dGrjosrOSt4uO979k7S3oUDZ4BA9CwV2EW2f8OUDzOj?= =?us-ascii?Q?HYJGuRSssdTthwzMx9KNrAqB7IuVm7ZkgDLrY1XrjxQ/SnxltAo7BDOTPDy/?= =?us-ascii?Q?n9TbDM8FgixvkyB2j9GGM/29INeoEyT4kT2mcjBR9kPW56FQZJALaaQVZWcM?= =?us-ascii?Q?Ja9CAEAIU0C3mFUXr8bkLZnszspyiqAReunO3jdAVjAn6+Rb1v7PGC4IRrRd?= =?us-ascii?Q?PD6NlbWJzD0fuCm41MQgXEuqLkmCq0DUA3eMGhwaMzb21lXv2kJeuW0NGnfO?= =?us-ascii?Q?GLi2G86W1l5ACtoDTDNaYB+XHno2Mv9QRYZFUq/7Jp2o8kXycsX8Rm/Z45Jx?= =?us-ascii?Q?KOdY/G3Rf84FCTZOK9no7gvWh2Gu+q6wnwSCaz+RFG5N6V5O5yUA4gnWiQ+X?= =?us-ascii?Q?eB3OmSI72PW1/J73ij4ny7EeVaKD+o9aojQrJ6UPbI5ezyYTufy6OeVWYDZF?= =?us-ascii?Q?qU6iVYy39gHzy77W3wYAK/xTbEs3neMrbF5U0ioI2/KkwJL4YmmY4sSMfOoF?= =?us-ascii?Q?XCiNRTswIHT0TBgimtHF6k8kCewOMIAxPnmyuFp+G7ETkROpMZyQ6BZjg+Kw?= =?us-ascii?Q?LtpAAwvKVXe75IuoZMinbwEdwMlg3pG9ibOOIuYNswQg0qYQFf2LVVEYVZ9y?= =?us-ascii?Q?aGsZHp2XQocfWb0cYcGWxeFFn1MFvAQRqpGXJzwuWc47T3yMk76Q/XfvHYIA?= =?us-ascii?Q?uHxIAm8CJ7avLalcjkNrSdf33GXAkqDS2t/PsvgpLtBjTxVxJtTwBdgSNIXO?= =?us-ascii?Q?oV7R0T72rZvxksR/R0K8E9Iap/O3mX5tkXxtC7TvyQBz0QshtCrAyKe90y4X?= =?us-ascii?Q?kvlwdx1FISBh6indqkFcjEoli7WzP9Z/atTYvoif+gu25YO8ORHhdQUxpUgA?= =?us-ascii?Q?vT1zq7AX6XAAH8Y1VBH++YgsA28xBdsLgcRq+0jMlZsSS4JSmdsOQ5Rf16JS?= =?us-ascii?Q?B3H3eBs0o8/LDoLUUpamj5D1/Q55RUdtrzbwrrK/wycwP90qkMSWtBeAg0Di?= =?us-ascii?Q?BXFJVEvBvYP4M4ulY8cdssZreP1QTxcby5jzRcSpM3UsVOTjyS3R7E//NfHL?= =?us-ascii?Q?9z?= X-Microsoft-Exchange-Diagnostics: 1; SN2PR03MB045; 6:C6GScrix7Gn0G2EE16SDvMPbptM54gGThCYsLQf6w9lsN0r45nYNNZ1i/6Xj5EXjuqX8V/VxOT6FL+kvGXKc+PxOUNBymGz/f2Bwey2C5fDAu7UN/P3jRgBj9guUN/LxnxWbWOQIDSVexWmGpafhbdooH6D2KJKBcd2r07xS/Sq0iAwztUVfnBuFykWw2/MM50l9O4UUyMFqFff1sYIkHmZbi2vfC3s76gXYPYLCzbqPcwHHADq5LN1ImyJ/J8NjP7g3U2ATvdOs7H8i7LjvvdURdZfX+J5E4UolHaWp6oewMK5vjeer0hRln3/Jw/osmblZhPVa8S2WcB4wqjMlOfaTKQOemuFFqJBPgTHkV1r9cm5B1T6VGnz8GwskoCrga9nEZdryamHQbyZfOjZ95ELX1kPZyIZwFwXSjcaRC3jeCO5Cw3CCNx4101abo5zYH8MtFBHVzaYtFaKlyvwavRO3cRFFajffTdG36eiHwVdPmhEE0EOsth5oHCyc670rgqA9NlkB9Ahf0gI+2D6YS1tGNDt3dW/S77/AlwqkCVw= X-Microsoft-Exchange-Diagnostics: 1; SN2PR03MB045; 5:x/twqxzb8CrsgCKhGUk+PGvCft1Ggre0s5fe1k6jDmZA1F9hJasW/Fk9zfXcfKGM5+P6/Dla7bXl/zaGSPFWhFERVWaDEtt6nAN5MJcIYc875AojzvB6GLiGly9XplQtfgyRa+Da8idJddvKv/IW68CnLb6u5LBN2xzS0PKThRsCrk8huKAnD6uIgxv9j0SFGQs0i7BDQfo8c/MtdKXMBwD8I8idgJ+IzPBWVRE+uaKTSEwQC4H7QSAAWaYeuI4sWtm8tVU6fvAvShUn9LiVXb5ZdtHBPKSq+aiXDQTxueumiOkpOXd/l6XCig3n30Vi2yfWqrPOAxYg1E4F8DjWFaDSAPxYdRHZjKQ9yDtSUOOHGoTr26LtCzjPeN0MNavSW/hcv3feAzL37GTjcU2fBhl5uKSh4fh+FOE1QebIV/2e95LA1yGMbvtdCIxGmxiPvlqN/xlKJMJQXqzgZZofBa+eg5uFws62GQLxlUxrkxyObfMwYM/6Kwtq9PIxM9gI; 24:VSgGE3wFuXurI68vs8n1mgRWvQmIXpNb/ESim7E7jhedkwRm+H9PzJgvCTYgJm47GuMCJZZ1P7VIzhpDb+/z5ukotKjXaLAIhVsRzYWtG9A= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1; SN2PR03MB045; 7:egK7DMtIXzGtjKQu37SNJVUeI6nFCb2xu214d0SzptZlDj+yLL5TmitqWkCD50Iu5SO80KnDCVeoLD21SneSJZwUJC7EXu4Ry3s0CqzVnHPoByyJMAoLITua27zoEepshuFDJaniFJXkSqDzdDGB7u1imuAqB9jf3zOaBL64pB/y2m46y7JzahlKkS2drw1LfvCkEXBoZrSt6hiBe+M0Fv30Ylgsc/kGb6cUhTV1KIwT177vkDb/WQUzr0c5vfr0w6r2VYOsOtzH+oCEholo7qT7Vb8xjjZITMSnt8cKA3EaUMUhOjRRTuQzM7ZHRQwpDywEi2uYqZ05At+A3cOkeQ== X-OriginatorOrg: ca.weatherford.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 13 Jun 2017 18:51:31.9243 (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: SN2PR03MB045 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:51:35 -0000 In prior testing I completely removed PostgreSQL from the equation by creat= ing a 16GB random file on the pertinent ZFS filesystem and reading after re= boot and later after the performance degradation hits. Read performance go= es from ~865MB/s with 95-100% busy in gstat down to ~61MB/s with ~10% busy. It's not Postgres. -----Original Message----- From: owner-freebsd-hackers@freebsd.org [mailto:owner-freebsd-hackers@freeb= sd.org] On Behalf Of Eduardo Morras via freebsd-hackers Sent: Tuesday, June 13, 2017 12:36 PM To: freebsd-hackers@freebsd.org Subject: Re: [EXTERNAL] Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD perfo= rmance drop < 24 hours On Mon, 12 Jun 2017 04:50:44 +0000 "Caza, Aaron" wrote: > Thanks, Jov, for you suggestions. Per your e-mail I added ?explain > analyze? to the script: Can you check that autovacuum is not involved in a lock storm? Autovacuums workers start to work but a higher level lock is acquired by ot= her process/transaction stopping autovacuum workers continuously, making au= tovacuum useless (but trying continually to clean). Also, you're comparing Postgresql 9.1 with 9.5, are you using the same conf= file? Did you upgrade it (conf file) to 9.5? --- --- Eduardo Morras _______________________________________________ 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" 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.