From owner-freebsd-performance@FreeBSD.ORG Wed Sep 30 18:06:50 2009 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 5926C1065692 for ; Wed, 30 Sep 2009 18:06:50 +0000 (UTC) (envelope-from vilmos.gyorgy@gmail.com) Received: from mail-ew0-f209.google.com (mail-ew0-f209.google.com [209.85.219.209]) by mx1.freebsd.org (Postfix) with ESMTP id AB0E98FC12 for ; Wed, 30 Sep 2009 18:06:49 +0000 (UTC) Received: by ewy5 with SMTP id 5so798861ewy.36 for ; Wed, 30 Sep 2009 11:06:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=/BhdKUa6LZDkWaT0FyvZ8ojGlBY8acOCbjb4mo/anhU=; b=B+gB1F1XxHFYF/SJNa2GHZskuRedyqNBypg4SJl1A/HzYKfFycgAYXVG/wveaJ+J9B sOljtjRkJyysurehUZIpJNphkO4W6JynsZWiCg1otFyphH3dgVe8P/hrz0JArzGck6l/ YJLDjE0fElUoCdoWl1duiSfwcYtqbzD7OFTdc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=QMrjzgGw0bImeofS8Ws+pC4yFE8TKeCG553hJKJzP1Pj1ZWnY22lVLD/inFjzRPRnn kKyYs7bH5morR3342ZM1dxZne1IETsYdKlBQi4dn/D5b2ZeliD23nT7/5jqZLWsMxzMo DlupMkR7fSXiHcWUNJsc2CB9DzQYqR73sA8g4= MIME-Version: 1.0 Received: by 10.216.73.197 with SMTP id v47mr24095wed.108.1254334007545; Wed, 30 Sep 2009 11:06:47 -0700 (PDT) In-Reply-To: <3bbf2fe10909290811p6ac49f7fxaf7e7d4bf631da4c@mail.gmail.com> References: <3bbf2fe10909290811p6ac49f7fxaf7e7d4bf631da4c@mail.gmail.com> Date: Wed, 30 Sep 2009 20:06:47 +0200 Message-ID: From: =?ISO-8859-1?Q?Gy=F6rgy_Vilmos?= To: Attilio Rao X-Mailman-Approved-At: Wed, 30 Sep 2009 19:52:32 +0000 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Content-Filtered-By: Mailman/MimeDel 2.1.5 Cc: freebsd-performance@freebsd.org Subject: Re: Performance evaluation of PostgreSQL's historic releases X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 30 Sep 2009 18:06:50 -0000 Hi, 2009/9/29 Attilio Rao > 2009/9/29 Gy=F6rgy Vilmos : > > Hi, > > > > I've done a benchmark of recent versions of PostgreSQL's last five majo= r > > releases to see how performance has changed during the past years from > > version to version. > > You can find the article here: > > http://suckit.blog.hu/2009/09/26/postgresql_history > > > > The tests were conducted on FreeBSD 8/amd64 on a midrange x86 server (4 > > CPUs, 24 cores, 128GiB RAM). > > Do you have informations about the systime when doing such tests? > I haven't got enough time to do the measurement right, so I could not log that. But according to top there were idle times. BTW, even on one thread, Linux (2.6.31) performs much better, better means here 790 TPS vs. 580... --=20 http://suckit.blog.hu/