From owner-freebsd-current@FreeBSD.ORG Sat Jun 28 10:21:44 2014 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 309BE2F0; Sat, 28 Jun 2014 10:21:44 +0000 (UTC) Received: from kib.kiev.ua (kib.kiev.ua [IPv6:2001:470:d5e7:1::1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id AAF4F29C4; Sat, 28 Jun 2014 10:21:43 +0000 (UTC) Received: from tom.home (kostik@localhost [127.0.0.1]) by kib.kiev.ua (8.14.9/8.14.9) with ESMTP id s5SALbTk058878 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Sat, 28 Jun 2014 13:21:37 +0300 (EEST) (envelope-from kostikbel@gmail.com) DKIM-Filter: OpenDKIM Filter v2.8.3 kib.kiev.ua s5SALbTk058878 Received: (from kostik@localhost) by tom.home (8.14.9/8.14.9/Submit) id s5SALbMN058877; Sat, 28 Jun 2014 13:21:37 +0300 (EEST) (envelope-from kostikbel@gmail.com) X-Authentication-Warning: tom.home: kostik set sender to kostikbel@gmail.com using -f Date: Sat, 28 Jun 2014 13:21:37 +0300 From: Konstantin Belousov To: Palle Girgensohn Subject: Re: PostgreSQL performance on FreeBSD Message-ID: <20140628102137.GA93733@kib.kiev.ua> References: <20140627125613.GT93733@kib.kiev.ua> <201406271057.53599.jhb@freebsd.org> <20140627163407.GX93733@kib.kiev.ua> <35090A62-2DB8-493C-A5ED-ADB1BC193640@pingpong.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="4TjORqrrURmsgxxJ" Content-Disposition: inline In-Reply-To: <35090A62-2DB8-493C-A5ED-ADB1BC193640@pingpong.net> User-Agent: Mutt/1.5.23 (2014-03-12) X-Spam-Status: No, score=-2.0 required=5.0 tests=ALL_TRUSTED,BAYES_00, DKIM_ADSP_CUSTOM_MED,FREEMAIL_FROM,NML_ADSP_CUSTOM_MED autolearn=no autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on tom.home Cc: "freebsd-current@freebsd.org" , "performance@freebsd.org" X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 28 Jun 2014 10:21:44 -0000 --4TjORqrrURmsgxxJ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Jun 28, 2014 at 12:08:39PM +0200, Palle Girgensohn wrote: >=20 >=20 > 27 jun 2014 kl. 18:34 skrev Konstantin Belousov : >=20 > > On Fri, Jun 27, 2014 at 10:57:53AM -0400, John Baldwin wrote: > >> On Friday, June 27, 2014 8:56:13 am Konstantin Belousov wrote: > >>> Hi, > >>> I did some measurements and hacks to see about the performance and > >>> scalability of PostgreSQL 9.3 on FreeBSD, sponsored by The FreeBSD > >>> Foundation. > >>>=20 > >>> The results are described in https://kib.kiev.ua/kib/pgsql_perf.pdf. > >>> The uncommitted patches, referenced in the article, are available as > >>> https://kib.kiev.ua/kib/pig1.patch.txt > >>> https://kib.kiev.ua/kib/patch-2 > >>=20 > >> Did you run the same benchmark on the same hardware with any other OS'= s to=20 > >> compare results? > >=20 > > No. > >=20 > > FWIW, before the failing after the 30 clients is corrected, I do not > > think it is much interesting to do such comparision. >=20 > This is great work! >=20 > Does anybody know how far back in FreeBSD versions using posix semaphore = instead of sysv would make a difference? It seems we need a rather current= version? 8.x did not support it at all, at some point at lest, and in 9 it= was buggy. I could add he patch-2 to the port, but I reckon it needs a con= ditional based on FreeBSD version? >=20 I recommend to add it as an option. The currently supported versions of stable/9 and higher have new posix semaphores implementation. The stable/8 also has posix semaphores, but there it is kernel-based interface, I do not plan to evaluate it in any way. > The clang bug should go upstreams, right? I believe there is already some activity about it. I do not follow clang development. >=20 > I have seen similar curves, presented by Greg Smith (PostgreSQL > hacker) where he concluded that there is no point in running more > than 50 concurrent connections. This was for Linux. In your measures, > the knee is at 30. That's said, FreeBSD could and should do better, > but probably there is a limit where there will be a knee in the graph > and performance will drop. It should be more than 30, though, as you > rightly commented. > > Do you any ideas to pursue this further apart from complicated > rewrites like DragonFly? > I do. The scope of the current work was done to obtain understanding where do we = stay and, if possible, evaluate ideas, possibly in the hackish way. I hope and almost sure that this will be continued, but cannot provide any time estimation. --4TjORqrrURmsgxxJ Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBAgAGBQJTrpcxAAoJEJDCuSvBvK1BYE8P/RYeGpegRSM7KT2+HlrW2zRO nGiXx7phK6+CJtUdzOvgrhuHkniI0e54t6qPF8q1XTtVNnPC+5nMWGuNoeJrMfPu +R29XDGcFNONovDDsbIuQgNq1J9foIQyKY6zFlgXl2jTtzuv2hwBoVP/BJ18mKRO ly51Ys+gRFQmdCcsU3GD+tp4q5VesNdOes9V3CBefEXNZPnFPgtULNh+mfVd+0aS jXfMo/2SRecUXG0rWBnB+5qJlySTJUmMzsaBaiWjTPQ0IlrMVcOTcwxc2cqM0GMt ihrPzdUEXoKZQt8qa36Otb71dcKdxQQVFjOf7aQMRbg4C66m2vwTIbAFurJnh8m/ GtAc9ebvYUBeAsqz2I6aacjfFCgc/Lg3dkLf5h0sCGfQoF8KhO0UGbSjWhPDmHw1 2MFIWs1q/gVsXgtpG2rnHwgEGVDbUQB/NwA8lwqyzU/x1+He2g8cT+Q2SO2dfa9u NEXoZhH7mJvbRQbXaJ+zhthtRC/wAr6RwWYA+T64/1RJxMv8Y2fjwMykYxVDQI6C rC3dddI+tgNOxe4hzoxLAd89K4kU0yA/xSz3q5pmZc/MO7bZ7zH1e26SwpGP5/yo TNTsNuo+buZUYqLvHYpbBwA0D+Uu/AGH14vkKpOJjoZAGd6/amt6jrX3rgJGVOYK sdGFeytYByDakUQfLu1H =3QOa -----END PGP SIGNATURE----- --4TjORqrrURmsgxxJ--