From owner-freebsd-performance@FreeBSD.ORG  Fri Jun 27 12:56:20 2014
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
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 53C5CA10;
 Fri, 27 Jun 2014 12:56:20 +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 418C82BDB;
 Fri, 27 Jun 2014 12:56:19 +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 s5RCuDgL053532;
 Fri, 27 Jun 2014 15:56:13 +0300 (EEST)
 (envelope-from kostikbel@gmail.com)
DKIM-Filter: OpenDKIM Filter v2.8.3 kib.kiev.ua s5RCuDgL053532
Received: (from kostik@localhost)
 by tom.home (8.14.9/8.14.8/Submit) id s5RCuDkd053531;
 Fri, 27 Jun 2014 15:56:13 +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 15:56:13 +0300
From: Konstantin Belousov <kostikbel@gmail.com>
To: performance@freebsd.org
Subject: PostgreSQL performance on FreeBSD
Message-ID: <20140627125613.GT93733@kib.kiev.ua>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature"; boundary="gw/jrspf8iiPX0nu"
Content-Disposition: inline
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: current@freebsd.org
X-BeenThere: freebsd-performance@freebsd.org
X-Mailman-Version: 2.1.18
Precedence: list
List-Id: Performance/tuning <freebsd-performance.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/options/freebsd-performance>, 
 <mailto:freebsd-performance-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-performance/>
List-Post: <mailto:freebsd-performance@freebsd.org>
List-Help: <mailto:freebsd-performance-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-performance>, 
 <mailto:freebsd-performance-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Fri, 27 Jun 2014 12:56:20 -0000


--gw/jrspf8iiPX0nu
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--gw/jrspf8iiPX0nu
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBAgAGBQJTrWnsAAoJEJDCuSvBvK1Bh5sP/2QSi4pgfmziDoMVip/rKwFB
DxMiTu2rl8sVWjWTB3Qd0zlk/glJwwZDmhprA+ovXJFsLlZBXSrZKvz+tP9Ug1RP
iZ5z87XCN37GMDnvYO7uh8dt/Z2HVRiPQA7GXTaDUEdycNUED1OhlH9X62fw4wM8
uuU5J1dsyf9Eh+MXyDhJPqf83l6wvgSbX8UOEhOOmcx/57jSaFm2elpGKHdWMhHV
bLGqbHv2TPek5BbsSUQhpAvrWG7j8iLf1QIbbYTkssu8jN4HtyceBKHLHm0vKU6E
uNWrvdRzl3ZSLWc1/oVKd2IESeSCDhQI4053gV4VQ+tD89D53d5eaIaxdEoYEuVO
TFyzAS6D4FtAnSiVuq9GKV4ChX2cA7hhI+l6AxM6RQ745gn3o60jQDNGvMyd0hg+
Mdy9e9vNSv9PQWwTOs2oUJXt9Y9Mkni01xq2fUz7w6ZBBlHmSdPH1H8GAHeFfDfh
9r3t1CIgY26Ff9kUHMgkWs7uBp6ly9QSAOIEPyVDWhbj6x88N3vIQ/V2k58vrhJW
VofYgmlz1M/6D7gi2KnVQll4n9EAzuviow05yfRJVVnGgAhvyKPrmyNxML6nQF26
/MvYBYpC9ceWPP7Mk7+xbWy3S1qqot1H+8U1nyUCYv2Qm40xRMFIH7hLcC3kb8M7
L9Hd8WjQ9Z9r/NxF0/Zz
=gNTr
-----END PGP SIGNATURE-----

--gw/jrspf8iiPX0nu--