From owner-freebsd-hackers@freebsd.org Wed Jun 14 17:20:22 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 B0CD9BEFEF4 for ; Wed, 14 Jun 2017 17:20:22 +0000 (UTC) (envelope-from allanjude@freebsd.org) Received: from mx1.scaleengine.net (mx1.scaleengine.net [209.51.186.6]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 8C0D4720B8 for ; Wed, 14 Jun 2017 17:20:22 +0000 (UTC) (envelope-from allanjude@freebsd.org) Received: from [10.1.1.2] (unknown [10.1.1.2]) (Authenticated sender: allanjude.freebsd@scaleengine.com) by mx1.scaleengine.net (Postfix) with ESMTPSA id C7C8313D72 for ; Wed, 14 Jun 2017 17:20:20 +0000 (UTC) Subject: Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours To: freebsd-hackers@freebsd.org References: <5fb864560929410bafc6a233d374c620@DM2PR58MB013.032d.mgd.msft.net> From: Allan Jude Message-ID: <42e7a692-974b-5b3f-a0a9-017850511e19@freebsd.org> Date: Wed, 14 Jun 2017 13:20:17 -0400 User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: <5fb864560929410bafc6a233d374c620@DM2PR58MB013.032d.mgd.msft.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="6vke97k0VGGJ73PVLCFaUL9kC9UxJ5DhJ" 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: Wed, 14 Jun 2017 17:20:22 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --6vke97k0VGGJ73PVLCFaUL9kC9UxJ5DhJ Content-Type: multipart/mixed; boundary="H5c9v3bQIxfLRrbnbmqa2qC1WPamANHLR"; protected-headers="v1" From: Allan Jude To: freebsd-hackers@freebsd.org Message-ID: <42e7a692-974b-5b3f-a0a9-017850511e19@freebsd.org> Subject: Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours References: <5fb864560929410bafc6a233d374c620@DM2PR58MB013.032d.mgd.msft.net> In-Reply-To: <5fb864560929410bafc6a233d374c620@DM2PR58MB013.032d.mgd.msft.net> --H5c9v3bQIxfLRrbnbmqa2qC1WPamANHLR Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 2017-06-14 13:11, Caza, Aaron wrote: > Further to this: >=20 > I've now tested FreeBSD 10.3-RELEASE-p19 and FreeBSD 11.0-STABLE #0 r30= 7264M, both of which suffer the same degraded performance. >=20 > test$ uname -a > FreeBSD xyz.com 10.3-RELEASE-p19 FreeBSD 10.3-RELEASE-p19 #0 r319904M: = Tue Jun 13 12:38:29 MDT 2017 aaronc@WFT:XYZ amd64 > test$ uptime > 10:15AM up 21:09, 2 users, load averages: 1.00, 1.14, 1.30 > test$ dd if=3D/testdb/test of=3D/dev/null bs=3D1m > 16000+0 records in > 16000+0 records out > 16777216000 bytes transferred in 200.379127 secs (83727363 bytes/sec) >=20 > After reboot: > test$ dd if=3D/testdb/test of=3D/dev/null bs=3D1m > 16000+0 records in > 16000+0 records out > 16777216000 bytes transferred in 23.213040 secs (722749623 bytes/sec) >=20 > Same Intel Xeon E31240 with 8GB ram and 2x Samsung 850 Pro 256GB SSDs a= s before. >=20 > 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 recipie= nt, do not read, copy, disclose or otherwise use this message. The sender= disclaims any liability for such unauthorized use. PLEASE NOTE that all = incoming e-mails sent to Weatherford e-mail accounts will be archived and= may be scanned by us and/or by external service providers to detect and = prevent threats to our systems, investigate illegal or inappropriate beha= vior, and/or eliminate unsolicited promotional e-mails (spam). This proce= ss could result in deletion of a legitimate e-mail before it is read by i= ts intended recipient at our organization. Moreover, based on the scannin= g results, the full text of e-mails and attachments may be made available= to Weatherford security and other personnel for review and appropriate a= ction. If you have any concerns about this process, > please contact us at dataprivacy@weatherford.com. > _______________________________________________ > freebsd-hackers@freebsd.org mailing list > https://lists.freebsd.org/mailman/listinfo/freebsd-hackers > To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.o= rg" >=20 Can you do the same test, but grab the memory lines from top(1) before and after each of those two runs. I am guessing the ARC is being squeezed out by PostgreSQL, because you have so little RAM. --=20 Allan Jude --H5c9v3bQIxfLRrbnbmqa2qC1WPamANHLR-- --6vke97k0VGGJ73PVLCFaUL9kC9UxJ5DhJ Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (MingW32) iQIcBAEBAgAGBQJZQXBUAAoJEBmVNT4SmAt+5mgP+gNMFFe1O735f7BUOyEYasMc Ixde4g0Q4lBXvIx2O6CaHTP9C4zWDS955S8UAXNmJ4CY5JrlQ9o1veJ8aTlj3geu uo5tHrm36W4ZbNKnTUbn+oqGtbccT1O2rhJJ9UmS5cfOp5nd8/iRIV6/iVZRJCDG qKhIFvDr+cDth2xkVLMmvUYqoNtQuD4lF9PTVkuOCNjP9zSICj5dtjL9et1Tujsf NgKBvnpNevJ3h1nU+Rh4Wev0mhECBWsrL1SkWitfIZwPH6Mhh16rJnw8uxn48Nn7 Egyb6/PXWs6Bg7IflACptzfGiec54D9RLsjD08WoRhcCu7Bodoth4We3KR+oBIDv yhMNK2GYmAFT42aaq8AP4oEHUzYoBWuRFdysVbDCsuVq8uiLjPXACaA9ZDAGgUvP o2AtVu9JZdEj2D0WqYAB6RCNWqWKnKyCuGs7/c5xcLat4ey3D14Z4hGO5XM20sLf XgPv0brB2XweujSH0dQkBRtkGosNsQAE85gjF1/X5/+qSrUzRdhrLnjqrl2zsLNg YdEfyGdmmmANXKl8+c+QAvri0yYbk/w7gsAAy/O1G4eeLPFukLcYosgpXjhqnEVx biGRpg7j3PwluQQduugoXMLdgrHZ4jH0Q7Sm2gsjlbV8zeWjhH6y7WDc4Y/v7D2o b10A9VoZaSu35PayCAA1 =rnGR -----END PGP SIGNATURE----- --6vke97k0VGGJ73PVLCFaUL9kC9UxJ5DhJ--