From owner-freebsd-performance@FreeBSD.ORG Fri Jun 27 16:34:14 2014 Return-Path: Delivered-To: performance@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 228465A7; Fri, 27 Jun 2014 16:34:14 +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 84A2B2247; Fri, 27 Jun 2014 16:34:13 +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 s5RGY7OJ003317 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 27 Jun 2014 19:34:08 +0300 (EEST) (envelope-from kostikbel@gmail.com) DKIM-Filter: OpenDKIM Filter v2.8.3 kib.kiev.ua s5RGY7OJ003317 Received: (from kostik@localhost) by tom.home (8.14.9/8.14.9/Submit) id s5RGY7qo003316; Fri, 27 Jun 2014 19:34:07 +0300 (EEST) (envelope-from kostikbel@gmail.com) X-Authentication-Warning: tom.home: kostik set sender to kostikbel@gmail.com using -f Date: Fri, 27 Jun 2014 19:34:07 +0300 From: Konstantin Belousov To: John Baldwin Subject: Re: PostgreSQL performance on FreeBSD Message-ID: <20140627163407.GX93733@kib.kiev.ua> References: <20140627125613.GT93733@kib.kiev.ua> <201406271057.53599.jhb@freebsd.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="vD4R8EutdGn5UgVK" Content-Disposition: inline In-Reply-To: <201406271057.53599.jhb@freebsd.org> 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-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, 27 Jun 2014 16:34:14 -0000 --vD4R8EutdGn5UgVK Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable 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 t= o=20 > compare results? No. FWIW, before the failing after the 30 clients is corrected, I do not think it is much interesting to do such comparision. --vD4R8EutdGn5UgVK Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBAgAGBQJTrZz/AAoJEJDCuSvBvK1BivAP/jQn+zI9GOk+h3mQtuQVH9KE t1W8101cwctwZ2ysLbg0OTOPGzmKeGm7NOK+PtDnoS6pl4BkV9QVhkE63WyQ3Ptg FclUM60nE15P6Z+sbS9Ol4SNGDAo6rPmEkDtKkOEIM2VvFr+F9pOyPlH4LwcP4g3 OiKI3+Wp8BaJTDrRwZRV2+f1VxuY2/kxFOPTTtjvOXwMMnUSRuCqpAvxB2nYny+H VurzG3Gac1yYHRfBnbfoFObbkYXo0ayFh5lWOCEIoCkF/G8NRZUgOuEvrj7yPWeL EnvehQZQT59c0fbwm2QoVczD9F85hiiF9mIHXxA+mpLWYIJZHdhCMNE0OecbRWOF uw9fE0iSDAguCMOmprPBJZM+EB0pqaJ40eS8a/AQ99SQBES60mCQIXlG7IF62Tiq exqQRrQEYTrMWUIaMIJfTHyQPIu9Xla2me3wG5vsSkpIpZPH2NCqXhL+kUiukLgS kNWbxMSF2zdev8KPZu065CUSOpLKSunxZyn8b0Y3eiW1IGmgKFpqpavq9xArNxjZ M2/i/ogVLPy/Di9l6ZUOkWEag+ypIFd+5P8GawQbNE+qnpXwGZEOAdBHqeBbAx9Z 2EZaNahwSikcWrjr3y0hMfyg2iM1M9TUiWlc7dt44TNpcM0yTegHJVrVkfWY0657 zpH131slsx43J2fb0iJZ =k5Mx -----END PGP SIGNATURE----- --vD4R8EutdGn5UgVK--