From owner-freebsd-questions@FreeBSD.ORG Fri Feb 23 17:42:27 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 40A9A16A402 for ; Fri, 23 Feb 2007 17:42:27 +0000 (UTC) (envelope-from h.schmalzbauer@omnisec.de) Received: from host.omnisec.de (host.omnisec.de [62.245.232.135]) by mx1.freebsd.org (Postfix) with ESMTP id 98FA713C4B2 for ; Fri, 23 Feb 2007 17:42:26 +0000 (UTC) (envelope-from h.schmalzbauer@omnisec.de) Received: from tek.flintsbach.schmalzbauer.de (tek.flintsbach.schmalzbauer.de [172.21.2.3]) by host.omnisec.de (8.13.8/8.13.8) with ESMTP id l1NHgItQ044497 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 23 Feb 2007 18:42:23 +0100 (CET) (envelope-from h.schmalzbauer@omnisec.de) Received: from titan.flintsbach.schmalzbauer.de (titan.flintsbach.schmalzbauer.de [IPv6:fec0::1:0:0:1:1]) by tek.flintsbach.schmalzbauer.de (8.13.8/8.13.8) with ESMTP id l1NHgIiG079473; Fri, 23 Feb 2007 18:42:18 +0100 (CET) (envelope-from h.schmalzbauer@omnisec.de) Received: from localhost (localhost [[UNIX: localhost]]) by titan.flintsbach.schmalzbauer.de (8.13.8/8.13.8/Submit) id l1NHgHB1004578; Fri, 23 Feb 2007 18:42:17 +0100 (CET) (envelope-from h.schmalzbauer@omnisec.de) From: Harald Schmalzbauer Organization: OmniSEC To: freebsd-questions@freebsd.org Date: Fri, 23 Feb 2007 18:42:17 +0100 User-Agent: KMail/1.9.4 References: <200702231729.15068.h.schmalzbauer@omnisec.de> <20070223120504.bef97395.wmoran@collaborativefusion.com> In-Reply-To: <20070223120504.bef97395.wmoran@collaborativefusion.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200702231842.17878.h.schmalzbauer@omnisec.de> Cc: Bill Moran Subject: Re: PotsgreSQL question (differences for 7.4 ,8.1 and 8.2) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 23 Feb 2007 17:42:27 -0000 Am Freitag, 23. Februar 2007 18:05 schrieb Bill Moran: > In response to Harald Schmalzbauer : > > Hello, > > > > I'm new to PostgreSQL and see that there are 3 versions in the Ports and > > bsd.mk.ports defaults to 7.4 to resolve pgsql dependencies. > > I yahood/msnd/googled a lot but couldn't find a comprehensive comparison > > regarding features/performance. There are severaly MySQL comparisions b= ut > > that aren't of interest any more since that's what I've been using > > before. > > > > So please can one explain me in short words what the main featrue > > difference is between 7.4, 8.1, 8.2? (I found out that 7.4 and 8.2 are > > incompatible regarding php5-pgsql conjunction) > > 7.4 is good. 8.1 is better. 8.2 is best. > > Feature changes are minimal. 8.2 has significant performance improvements > over previous version. Version or versions? I mean, even better than 7.4? I read some tests that=20 performance of 8.x is in some statements a big regression (runtime 25ms on= =20 7.4 while 8.x needs 1000ms (1s!)) It sounds that you have done some real world and sensible tests, that's why= =20 I'm asking. I don't give too much for synthetic benchmark results, but a=20 factor of 40 surely would be noticable in real world... Thanks, =2DHarry =20 =2D-=20 OmniSEC - UNIX und Windows Netzwerke - Sicher Harald Schmalzbauer =46lintsbacher Str. 3 80686 M=FCnchen +49 (0) 89 18947781 +49 (0) 160 93860101