Date: Wed, 14 Jun 2017 13:20:17 -0400 From: Allan Jude <allanjude@freebsd.org> To: freebsd-hackers@freebsd.org Subject: Re: FreeBSD10 Stable + ZFS + PostgreSQL + SSD performance drop < 24 hours Message-ID: <42e7a692-974b-5b3f-a0a9-017850511e19@freebsd.org> In-Reply-To: <5fb864560929410bafc6a233d374c620@DM2PR58MB013.032d.mgd.msft.net> References: <5fb864560929410bafc6a233d374c620@DM2PR58MB013.032d.mgd.msft.net>
next in thread | previous in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --6vke97k0VGGJ73PVLCFaUL9kC9UxJ5DhJ Content-Type: multipart/mixed; boundary="H5c9v3bQIxfLRrbnbmqa2qC1WPamANHLR"; protected-headers="v1" From: Allan Jude <allanjude@freebsd.org> 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--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?42e7a692-974b-5b3f-a0a9-017850511e19>