From owner-freebsd-questions@FreeBSD.ORG Fri Feb 23 19:34:18 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 64C0616A404 for ; Fri, 23 Feb 2007 19:34:18 +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 D571613C442 for ; Fri, 23 Feb 2007 19:34:17 +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 l1NJY9tn045725 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 23 Feb 2007 20:34:15 +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 l1NJY9Gm005160; Fri, 23 Feb 2007 20:34:09 +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 l1NJY9UQ005505; Fri, 23 Feb 2007 20:34:09 +0100 (CET) (envelope-from h.schmalzbauer@omnisec.de) From: Harald Schmalzbauer Organization: OmniSEC To: freebsd-questions@freebsd.org Date: Fri, 23 Feb 2007 20:34:09 +0100 User-Agent: KMail/1.9.4 References: <200702231729.15068.h.schmalzbauer@omnisec.de> <200702231842.17878.h.schmalzbauer@omnisec.de> <20070223131713.39a96d18.wmoran@collaborativefusion.com> In-Reply-To: <20070223131713.39a96d18.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: <200702232034.09411.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 19:34:18 -0000 Am Freitag, 23. Februar 2007 19:17 schrieb Bill Moran: > In response to Harald Schmalzbauer : [...] > > > 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 th= at > > performance of 8.x is in some statements a big regression (runtime 25ms > > on 7.4 while 8.x needs 1000ms (1s!)) > > Where did you read this? On one of the hundred pages I visited when collecting infos... [...] > I don't have any real-world tests that could give any real numbers between > specific versions. My answer is based on personal "feel" over the last > few years, as well as involvement with the postgres-perform mailing lists. Ok, but perhaps you can answer me another question: What are the command syntax changes between 7.4 and 8.1? Are there likewise= =20 changes (thus incompatibilities) between 8.1 and 8.2? I use eGroupWare and restoring a backup (orginating for a MySQL databse) wo= rks=20 with pgsql 7.4 but not with 8.2 (using php5-pgsql). Thanks a lot, =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