From owner-freebsd-performance@FreeBSD.ORG Fri Jun 27 14:00:08 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 8D2B9F84; Fri, 27 Jun 2014 14:00:08 +0000 (UTC) Received: from mail.feld.me (mail.feld.me [66.170.3.6]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mail.feld.me", Issuer "Gandi Standard SSL CA" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 2D8992221; Fri, 27 Jun 2014 14:00:07 +0000 (UTC) Received: from mail.feld.me (mail.feld.me [66.170.3.6]); by mail.feld.me (OpenSMTPD) with ESMTP id 18724661; Fri, 27 Jun 2014 08:53:26 -0500 (CDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=feld.me; h=mime-version :date:content-type:message-id:from:subject:to:cc:in-reply-to :references:sender; s=blargle2; bh=QHp5kyOwcji/8sYH0H7go2vvmGE=; b= T2Q4GMvkZGKMJ1mud/wS5wbWvmWGHQ5SgB3RxSuCgvSgl1HAD4Jh9cYB6JhtZ+ic srRIXnyLw2R42A9PTSXqJUcGxsnzFmXv1nADSYyXmSUutJZyRIuFYYjUGJ6MZkNT 34QWulARgX5b1NueJjLFbLhDfeRaDQM0R1yqsVllaGn78ZY4aV5pfaJEWPoLTPib tb+ZN3tpI0GCsiBboqRZUX0qdTBmGOzE3ikVu9MM18cGU+uVuM5MLWefEV5fKWEz wgAM7eNHOzuCttTUoiL6RMBbjgPpezJ0MYk6p8QDz/i5xTnW9vrRPJpj/Mw75Za8 fekadck5sFQ/yDuFg4zwrA== DomainKey-Signature: a=rsa-sha1; c=nofws; d=feld.me; h=mime-version:date :content-type:message-id:from:subject:to:cc:in-reply-to :references:sender; q=dns; s=blargle2; b=CrY0WRhU+qJEtFWq3NYkyA4 HXVjhGJplG84j/v8/JZ6NZ9lfd2emgRjtJEYNvXS5OkLT6waxh3WbLJzfqTf91JA e5Q1SOIZhabisIquvXO32lLFNFI6qN2xNu8FEtOJFYgH87JSBwZ9VA5/KDuc2cSj 1JITPBh47TNM7RHWYZ+pOe+2fOsNPt1+Y6tb+S4aCw417xJUdkKPKKXM0cA65PXD shcfGWMMNBJ8jDJ/6a07e1Ms28SSRRRyc+cn/wMClMmmKkehDpQQDP2aZMjJ6/VA QoTDilUoIQf2HOfKPws0AdZjQU8RMlZWleTEeQAOft6y8xKDbDQNTUouJmsUksw= = Received: from mail.feld.me (mail.feld.me [66.170.3.6]); by mail.feld.me (OpenSMTPD) with ESMTP id 966a52e7; Fri, 27 Jun 2014 08:53:26 -0500 (CDT) Received: from feld@feld.me by mail.feld.me (Archiveopteryx 3.2.0) with esmtpa id 1403877205-4188-4185/5/6; Fri, 27 Jun 2014 13:53:25 +0000 Mime-Version: 1.0 Date: Fri, 27 Jun 2014 13:53:25 +0000 Content-Type: text/plain; charset=utf-8 Message-Id: <3fc51f4ac40910455d761c6cd2b150c7@mail.feld.me> X-Mailer: RainLoop/1.6.7.132 From: Mark Felder Subject: Re: PostgreSQL performance on FreeBSD To: Konstantin Belousov , performance@freebsd.org In-Reply-To: <20140627125613.GT93733@kib.kiev.ua> References: <20140627125613.GT93733@kib.kiev.ua> Sender: feld@feld.me Cc: 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, 27 Jun 2014 14:00:08 -0000 June 27 2014 7:56 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. > > 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 > Thank you for taking the time to do this benchmark.