Skip site navigation (1)Skip section navigation (2)
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: <http://docs.FreeBSD.org/cgi/mid.cgi?200702232034.09411.h.schmalzbauer>