From owner-freebsd-questions@FreeBSD.ORG Fri Feb 23 16:48:19 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 A50F416A400 for ; Fri, 23 Feb 2007 16:48:19 +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 2789513C441 for ; Fri, 23 Feb 2007 16:48:18 +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 l1NGTF8h043672 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Fri, 23 Feb 2007 17:29:20 +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 l1NGTFCe009170 for ; Fri, 23 Feb 2007 17:29:15 +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 l1NGTFJ2003992 for freebsd-questions@freebsd.org; Fri, 23 Feb 2007 17:29:15 +0100 (CET) (envelope-from h.schmalzbauer@omnisec.de) From: Harald Schmalzbauer Organization: OmniSEC To: freebsd-questions@freebsd.org Date: Fri, 23 Feb 2007 17:29:14 +0100 User-Agent: KMail/1.9.4 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200702231729.15068.h.schmalzbauer@omnisec.de> Subject: 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 16:48:19 -0000 Hello, I'm new to PostgreSQL and see that there are 3 versions in the Ports and=20 bsd.mk.ports defaults to 7.4 to resolve pgsql dependencies. I yahood/msnd/googled a lot but couldn't find a comprehensive comparison=20 regarding features/performance. There are severaly MySQL comparisions but=20 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 differenc= e=20 is between 7.4, 8.1, 8.2? (I found out that 7.4 and 8.2 are incompatible=20 regarding php5-pgsql conjunction) And what are the main performace differences (for a very small site) betwee= n=20 7.4, 8.1 and 8.2? If it's not obvious (with the above answered), why are there 3 stable=20 branches? Thanks a lot in advance, =2DHarry =2D-=20 OmniSEC - UNIX und Windows Netzwerke - Sicher Harald Schmalzbauer =46lintsbacher Str. 3 80686 M=FCnchen +49 (0) 89 18947781 +49 (0) 160 93860101