From owner-freebsd-current@FreeBSD.ORG Wed Jul 16 13:29:44 2014 Return-Path: Delivered-To: current@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 59C1AA4A; Wed, 16 Jul 2014 13:29: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 BD0612877; Wed, 16 Jul 2014 13:29:43 +0000 (UTC) Received: from tom.home (kib@localhost [127.0.0.1]) by kib.kiev.ua (8.14.9/8.14.9) with ESMTP id s6GDTc1E083792 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Wed, 16 Jul 2014 16:29:38 +0300 (EEST) (envelope-from kostikbel@gmail.com) DKIM-Filter: OpenDKIM Filter v2.8.3 kib.kiev.ua s6GDTc1E083792 Received: (from kostik@localhost) by tom.home (8.14.9/8.14.9/Submit) id s6GDTcmK083791; Wed, 16 Jul 2014 16:29:38 +0300 (EEST) (envelope-from kostikbel@gmail.com) X-Authentication-Warning: tom.home: kostik set sender to kostikbel@gmail.com using -f Date: Wed, 16 Jul 2014 16:29:38 +0300 From: Konstantin Belousov To: performance@freebsd.org, current@freebsd.org Subject: Re: PostgreSQL performance on FreeBSD Message-ID: <20140716132938.GB93733@kib.kiev.ua> References: <20140627125613.GT93733@kib.kiev.ua> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="MS56pFM3hjr8joCS" Content-Disposition: inline In-Reply-To: <20140627125613.GT93733@kib.kiev.ua> 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 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: Wed, 16 Jul 2014 13:29:44 -0000 --MS56pFM3hjr8joCS Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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. >=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 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'. --MS56pFM3hjr8joCS Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBAgAGBQJTxn5CAAoJEJDCuSvBvK1Bv2YP/2CLnhKXwVqvqY314KyRc2mN dD9JM6lQrzzG59MmEAWjdwmSI04OCJ77etczzbrpPtay9aQYWGitYOtqumAPVGSa g3nV/IW1orZPaZESlbFepSwqR8P56FEWXREt5VA/BbFIdHgJAqjIQTxxSveoQY1u htY8R6BDzww6e7qDFMnUP/sL6MOnnEkz2XJimZT/D2w2ve0Z5A12wpqy336p40bH utaM44RQwIMBKoTLKlmRhGfwCrd6GCRBvvEYFgAWyjcZqxeUARS5i1h1PyiduQ+w kWNY9Y1IjUAC7PCRQ92/DoNXlZVI6peOSuDZF6lYA0inTMwNDqcWlQBlujk77mzu gUG9fp1Cy5dp01LiLJHQBdi8hnxkEfZ6ufm6jdttaVcPGmPAqSNyB70v80QpOg/C 8hMtRG080u4fpEsvm0qvHdTHK/+LoIZ+Mr6FZYUij26BxFABzOD/lP7yXvplwsWV ac7MkfvMgltG1U1MChqb5bwNc6qDgaOJOVQtgMD9wQNU29J94+fkL+I5xYUDjwQZ +LREG8yz3a082aujy4coT+HYyRFnzsYlM6ixjISBqoeG1gZ1EPf2UnpmrK/baGSh xq9+08bnW8lshgRn/qqrOczIWPQm6ONYRVEgbdn7dLCWxtRw7mNbj36FORXCK6kU 0yzHzfqqz7CBbqXfiqSR =X0m2 -----END PGP SIGNATURE----- --MS56pFM3hjr8joCS--