planning to upgrade to 8.1 - Mailing list pgsql-general

From surabhi.ahuja
Subject planning to upgrade to 8.1
Date
Msg-id 8626C1B7EB748940BCDD7596134632BE398690@jal.iiitb.ac.in
Whole thread Raw
In response to Preformace boost -- by 8.0.4 upgrade to 8.1.4  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: planning to upgrade to 8.1
List pgsql-general
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

pgsql-general by date:

Previous
From: "Christian Rengstl"
Date:
Subject: Question concerning arrays
Next
From: Alvaro Herrera
Date:
Subject: Re: auto-vacuum & Negative "anl" Values