I am currently using 8.0.0, i heard that 8.1 can help in performance boost especially if the system is multi core processor.
i am also planning to upgrade.
To which version should i upgrade?
Also Please tell if ther will be a need to build my programs again.
I mean is it ok if i use the same libpq stuff.
Only the server needs to be upgraded, or i need to build with new libpq.
Thanks,
regards
Surabhi
From: pgsql-general-owner@postgresql.org on behalf of Richard Broersma Jr
Sent: Tue 6/27/2006 10:17 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Preformace boost -- by 8.0.4 upgrade to 8.1.4
Hello list,
I am happy to report that I am seeing a 150% average increase in select performance since I
upgraded to 8.1.4.
Version
--------
PostgreSQL 8.1.4 on i686-pc-linux-gnu,
compiled by GCC i686-pc-linux-gnu-gcc (GCC) 3.4.6
(Gentoo 3.4.6-r1, ssp-3.4.5-1.0, pie-8.7.9)
Not to mention, the upgrade was a snap! I am happy most of all for the documentation of the 8.1.4
manual.
The total upgrade time, including building from source was about an hour.
I want to express my appreciation for all of the hard work, ingenuity, and support offered by the
PostgreSQL Developers and Community.
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly