From owner-freebsd-performance@FreeBSD.ORG  Tue Jul 15 20:46:25 2014
Return-Path: <owner-freebsd-performance@FreeBSD.ORG>
Delivered-To: freebsd-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 CFC5ED21;
 Tue, 15 Jul 2014 20:46:25 +0000 (UTC)
Received: from mail-ob0-x231.google.com (mail-ob0-x231.google.com
 [IPv6:2607:f8b0:4003:c01::231])
 (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits))
 (Client CN "smtp.gmail.com",
 Issuer "Google Internet Authority G2" (verified OK))
 by mx1.freebsd.org (Postfix) with ESMTPS id 8E67422CB;
 Tue, 15 Jul 2014 20:46:25 +0000 (UTC)
Received: by mail-ob0-f177.google.com with SMTP id wp18so6243147obc.22
 for <multiple recipients>; Tue, 15 Jul 2014 13:46:24 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:sender:in-reply-to:references:from:date:message-id
 :subject:to:cc:content-type;
 bh=zMnM9QOXPtVagQ5aOuXf8cm+BMIh2qls2SKpcYGkhNY=;
 b=lQeRFmV7EHEtgBf5G5S0SNxxwBgwm7Gg0Qp4uEg6CmKRWLuRLZH0bcTl+2k3kxMtWR
 hc1e4+WMPWGFJ725VzdUEiu5FiUIRu0mRDIbxA9gWIerxTGUU3ukCEoV1ZfDqM7YxVRW
 uZcwM7Z1FzUd+TMHVC0uSIEzYdPrMNRWLO+A15BLvXMT6OFk2zobADJb1KqZu6UMhbvY
 MzGZ85E3oYS7pY3y7mgjl+WQa7tCNBQkl/qopfzsccpxkHh/1MGQYc9p0Z6CCZ1Tg+0q
 bodrCeyXTlcP4PG8Xg/Dj2yXCl67gRKMIg7c8cddClRiELHKXyjgoVRIrZTElHDuZrDW
 N2aw==
X-Received: by 10.182.233.230 with SMTP id tz6mr29243221obc.53.1405457184804; 
 Tue, 15 Jul 2014 13:46:24 -0700 (PDT)
MIME-Version: 1.0
Sender: ivoras@gmail.com
Received: by 10.202.231.195 with HTTP; Tue, 15 Jul 2014 13:45:44 -0700 (PDT)
In-Reply-To: <9D3FE91D-7806-4D89-8158-E54D7050D8D5@FreeBSD.org>
References: <20140627125613.GT93733__16271.4854618118$1403873797$gmane$org@kib.kiev.ua>
 <lpgit9$okg$1@ger.gmane.org>
 <9D3FE91D-7806-4D89-8158-E54D7050D8D5@FreeBSD.org>
From: Ivan Voras <ivoras@freebsd.org>
Date: Tue, 15 Jul 2014 22:45:44 +0200
X-Google-Sender-Auth: st0lsVey92HvWHWeoJD_-2CWFNM
Message-ID: <CAF-QHFXkZmeqUX94QBWMB1JWdBOiX4XNyNQCn4yS=sxxn5tnvw@mail.gmail.com>
Subject: Re: PostgreSQL performance on FreeBSD
To: Mark Felder <feld@freebsd.org>
Content-Type: text/plain; charset=UTF-8
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 20:46:25 -0000

On 8 July 2014 13:41, Mark Felder <feld@freebsd.org> wrote:
>
> On Jul 8, 2014, at 5:58, Ivan Voras <ivoras@freebsd.org> wrote:

>> 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?
>>
>
> What Postgres version are you running? If you're still on 9.2 I don't believe it would show a performance degradation.

Since I'm going into downtime for the upgrade anyway, I'm going to
upgrade both PostgreSQL and FreeBSD to 10.x at the same time, and
since it looks that it would be prudent NOT to upgrade to PostgreSQL
9.3+ from any release of FreeBSD, I'm going to wait for the patches to
hit a RELEASE.

Btw PostgreSQL 9.4 is just around the corner.