Skip site navigation (1)Skip section navigation (2)
Date:      Fri, 23 Feb 2007 12:05:04 -0500
From:      Bill Moran <wmoran@collaborativefusion.com>
To:        Harald Schmalzbauer <h.schmalzbauer@omnisec.de>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: PotsgreSQL question (differences for 7.4 ,8.1 and 8.2)
Message-ID:  <20070223120504.bef97395.wmoran@collaborativefusion.com>
In-Reply-To: <200702231729.15068.h.schmalzbauer@omnisec.de>
References:  <200702231729.15068.h.schmalzbauer@omnisec.de>

Next in thread | Previous in thread | Raw E-Mail | Index | Archive | Help
In response to Harald Schmalzbauer <h.schmalzbauer@omnisec.de>:

> 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 but 
> 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.

> And what are the main performace differences (for a very small site) between 
> 7.4, 8.1 and 8.2?
> If it's not obvious (with the above answered), why are there 3 stable 
> branches?

Legacy support.  Some applications only work on older versions.  Additionally,
in an enterprise environment, people don't upgrade just every time a
new version comes out (don't tell Microsoft, that'd defeat their entire
business model).  We're still evaluating 8.2, and we'll be using 8.1
until we've don't a LOT of testing to ensure there are no regressions
with 8.2.

You should read Eric Raymond's _The_Art_of_Unix_Programming_.  Especially
the section about multiple development branches.

-- 
Bill Moran
Collaborative Fusion Inc.



Want to link to this message? Use this URL: <http://docs.FreeBSD.org/cgi/mid.cgi?20070223120504.bef97395.wmoran>