Date: Fri, 23 Feb 2007 20:34:09 +0100 From: Harald Schmalzbauer <h.schmalzbauer@omnisec.de> To: freebsd-questions@freebsd.org Cc: Bill Moran <wmoran@collaborativefusion.com> Subject: Re: PotsgreSQL question (differences for 7.4 ,8.1 and 8.2) Message-ID: <200702232034.09411.h.schmalzbauer@omnisec.de> In-Reply-To: <20070223131713.39a96d18.wmoran@collaborativefusion.com> References: <200702231729.15068.h.schmalzbauer@omnisec.de> <200702231842.17878.h.schmalzbauer@omnisec.de> <20070223131713.39a96d18.wmoran@collaborativefusion.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Am Freitag, 23. Februar 2007 19:17 schrieb Bill Moran: > In response to Harald Schmalzbauer <h.schmalzbauer@omnisec.de>: [...] > > > 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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200702232034.09411.h.schmalzbauer>