From owner-freebsd-performance@FreeBSD.ORG Tue Jul 15 19:00:16 2014 Return-Path: <owner-freebsd-performance@FreeBSD.ORG> Delivered-To: freebsd-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 0AEFF31F; Tue, 15 Jul 2014 19:00:16 +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 7DEAA2845; Tue, 15 Jul 2014 19:00:15 +0000 (UTC) Received: from mail.feld.me (mail.feld.me [66.170.3.6]); by mail.feld.me (OpenSMTPD) with ESMTP id ae4424fa; Tue, 15 Jul 2014 13:53:32 -0500 (CDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=feld.me; h=content-type :mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:sender; s= blargle2; bh=p6RoxLIql1QwD75BRABtNQKN1/g=; b=1AR92nZMndod8CeA3KE +0G1MUUcKTim1IkA2LYSQOCqnec0XgVkt+7OoEbIvQYmiqLiX7ljyA5ZL4w6OACi ddoDngWviKzsd0fBU/DfX/Ff7GTIz9tFMGjd5MfeZHYJuTZeNL0Y4eAnSyurXRE8 emrWeHpF+XQp5opXTS7+mBoyec0mo1IgoRCVc7MI4TGpiCzIf1SGZR3HY3w+zoki aPO0RokdXIexkgzLDSnnq/n+h3DSfmhlePxlFFIWpwiJNWcTwxViaKESj6qpGRzY jhVls+vZSzxMzT6kfOz0Fkzrg2HiUsZ/oCkX02NaNtYBn0FjcYfCmH3OWWkKxHKI kiw== DomainKey-Signature: a=rsa-sha1; c=nofws; d=feld.me; h=content-type :mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to:sender; q= dns; s=blargle2; b=aNv1aXnENLjvGmD2RuZh4V7O6PxuUgOmBqm8LeAvOYL/q u7vvn1mpa3+sMmroSq3EpvFknux46C/e4a/Ok93cEQDVz9bkAmVSXk0nUZtGy8LQ nt9gKcsdsXeIqEIAk7cqnN4MQn9R+qZXhLblikLBTcoCTzbWg6eIJXy5i2NRVhlU E6d9HWcZE0gVhSuR3IrhfNfjvQF8LRJTaxshu6xJEv0z7cCdbXsuQqwVm9HWlpgQ kC/4i39iZAc4UeOeZUD2Jsa2LMavMbeoby/3QHbz6wQewiHymQ4AUxjNPj2VKBtx 69Xi/CX2UL2V8SXzAGvHChKUIo4QY/Kj594+K2xvQ== Received: from mail.feld.me (mail.feld.me [66.170.3.6]); by mail.feld.me (OpenSMTPD) with ESMTP id 58d01fd9; Tue, 15 Jul 2014 13:53:32 -0500 (CDT) Received: from feld@feld.me by mail.feld.me (Archiveopteryx 3.2.0) with esmtpa id 1404819669-4187-4185/5/15; Tue, 8 Jul 2014 11:41:09 +0000 Content-Type: text/plain Mime-Version: 1.0 Subject: Re: PostgreSQL performance on FreeBSD From: Mark Felder <feld@freebsd.org> In-Reply-To: <lpgit9$okg$1@ger.gmane.org> Date: Tue, 8 Jul 2014 06:41:07 -0500 Content-Transfer-Encoding: quoted-printable Message-Id: <9D3FE91D-7806-4D89-8158-E54D7050D8D5@FreeBSD.org> References: <20140627125613.GT93733__16271.4854618118$1403873797$gmane$org@kib.kiev.ua> <lpgit9$okg$1@ger.gmane.org> To: Ivan Voras <ivoras@freebsd.org> X-Mailer: Apple Mail (2.1878.6) Sender: feld@feld.me Cc: freebsd-performance@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: Tue, 15 Jul 2014 19:00:16 -0000 On Jul 8, 2014, at 5:58, Ivan Voras <ivoras@freebsd.org> wrote: > On 27/06/2014 14:56, 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 > I'm waiting to upgrade some PostgreSQL machines running FreeBSD 9 to > FreeBSD 10 - are the patches committed yet / will they be committed for > 10.1? >=20 What Postgres version are you running? If you're still on 9.2 I don't = believe it would show a performance degradation.