planning to upgrade to 8.1

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(at)postgresql(dot)org on behalf of Richard Broersma Jr
Sent: Tue 6/27/2006 10:17 AM
To: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly