Date: Fri, 18 Jul 2014 07:54:16 +0200 From: "O. Hartmann" <ohartman@zedat.fu-berlin.de> To: Hooman Fazaeli <hoomanfazaeli@gmail.com> Cc: Konstantin Belousov <kostikbel@gmail.com>, performance@freebsd.org, current@freebsd.org 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>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --] Am Thu, 17 Jul 2014 20:15:39 +0430 Hooman Fazaeli <hoomanfazaeli@gmail.com> 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'. > > Thanks for the great work! > > Did you tested the effect of hyper-threading (on or off) on the results? > > A "naive" question besides: Does this labor and effort only affects the work with the PostgreSQL 9.3 database and is recent FreeBSD only optimized for this servicing puprpose or provides this also some benefeits for other high-performance scenarios? Oliver [-- Attachment #2 --] -----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-----help
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20140718075416.2bde7e9d.ohartman>