Date: Fri, 23 Feb 2007 18:42:17 +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: <200702231842.17878.h.schmalzbauer@omnisec.de> In-Reply-To: <20070223120504.bef97395.wmoran@collaborativefusion.com> References: <200702231729.15068.h.schmalzbauer@omnisec.de> <20070223120504.bef97395.wmoran@collaborativefusion.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Am Freitag, 23. Februar 2007 18:05 schrieb Bill Moran: > 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 b= ut > > 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. Version or versions? I mean, even better than 7.4? I read some tests that=20 performance of 8.x is in some statements a big regression (runtime 25ms on= =20 7.4 while 8.x needs 1000ms (1s!)) It sounds that you have done some real world and sensible tests, that's why= =20 I'm asking. I don't give too much for synthetic benchmark results, but a=20 factor of 40 surely would be noticable in real world... Thanks, =2DHarry =20 =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?200702231842.17878.h.schmalzbauer>