From owner-freebsd-performance@FreeBSD.ORG Fri Jul 18 05:54:26 2014 Return-Path: Delivered-To: performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 45B482C9; Fri, 18 Jul 2014 05:54:26 +0000 (UTC) Received: from outpost1.zedat.fu-berlin.de (outpost1.zedat.fu-berlin.de [130.133.4.66]) (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 F34B52A55; Fri, 18 Jul 2014 05:54:25 +0000 (UTC) Received: from inpost2.zedat.fu-berlin.de ([130.133.4.69]) by outpost.zedat.fu-berlin.de (Exim 4.82) with esmtp (envelope-from ) id <1X817e-001nT0-RT>; Fri, 18 Jul 2014 07:54:22 +0200 Received: from e179168030.adsl.alicedsl.de ([85.179.168.30] helo=thor.walstatt.dynvpn.de) by inpost2.zedat.fu-berlin.de (Exim 4.82) with esmtpsa (envelope-from ) id <1X817e-0004wl-Nq>; Fri, 18 Jul 2014 07:54:22 +0200 Date: Fri, 18 Jul 2014 07:54:16 +0200 From: "O. Hartmann" To: Hooman Fazaeli Subject: Re: PostgreSQL performance on FreeBSD Message-ID: <20140718075416.2bde7e9d.ohartman@zedat.fu-berlin.de> In-Reply-To: <53C7EFA3.3070100@gmail.com> References: <20140627125613.GT93733@kib.kiev.ua> <20140716132938.GB93733@kib.kiev.ua> <53C7EFA3.3070100@gmail.com> Organization: FU Berlin X-Mailer: Claws Mail 3.10.1 (GTK+ 2.24.22; amd64-portbld-freebsd11.0) MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; boundary="Sig_/ktPsIHr7PD1VnsaAGF96FL2"; protocol="application/pgp-signature" X-Originating-IP: 85.179.168.30 X-ZEDAT-Hint: A Cc: Konstantin Belousov , performance@freebsd.org, current@freebsd.org X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 18 Jul 2014 05:54:26 -0000 --Sig_/ktPsIHr7PD1VnsaAGF96FL2 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Am Thu, 17 Jul 2014 20:15:39 +0430 Hooman Fazaeli schrieb: > On 7/16/2014 5:59 PM, Konstantin Belousov wrote: > > On Fri, Jun 27, 2014 at 03:56:13PM +0300, 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. > >> > >> 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 > > A followup to the original paper. > > > > Most importantly, I identified the cause for the drop on the graph > > after the 30 clients, which appeared to be the debugging version > > of malloc(3) in libc. > > > > Also there are some updates on the patches. > > > > New version of the paper is available at > > https://www.kib.kiev.ua/kib/pgsql_perf_v2.0.pdf > > The changes are marked as 'update for version 2.0'. >=20 > Thanks for the great work! >=20 > Did you tested the effect of hyper-threading (on or off) on the results? >=20 >=20 A "naive" question besides: Does this labor and effort only affects the work with the PostgreSQL 9.3 da= tabase and is recent FreeBSD only optimized for this servicing puprpose or provides this = also some benefeits for other high-performance scenarios? Oliver=20 --Sig_/ktPsIHr7PD1VnsaAGF96FL2 Content-Type: application/pgp-signature; name=signature.asc Content-Disposition: attachment; filename=signature.asc -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQEcBAEBAgAGBQJTyLaOAAoJEOgBcD7A/5N8MdIIAKTL6TAh/N2rDVC8qx4tIN7V DiSLcK2cBfkEXgPXJc6krk6QwDE5aTCJh3XUrnp2Fq8YSk+hK1+aVy/4Chr6oe7X q1wi1UNOvl6FPPntKZI7GFp2ML/1kjwKRMV/JKTfqOXegvlB/jLaEXi0wFkBUnRL mLnHXf3ORR4asBtleEstFe6YAdwfHwPV5jNs/lZrL9n62I7kf5UyR4e2xHqTrg29 23VNeAkfpqTDpLLAvZmjD4qBev1UtuqqCVwHqbJdPDF/dmXr+tJqWXh8xps4/6++ t1MeVq34uZlOyDZ7l6W/q8UzUx9E+p9wttFLfsksJmZfGFVQ3QQR6ooRXBSLJxE= =Qr8a -----END PGP SIGNATURE----- --Sig_/ktPsIHr7PD1VnsaAGF96FL2--