Preformace boost -- by 8.0.4 upgrade to 8.1.4

Started by Richard Broersma Jralmost 20 years ago9 messagesgeneral

rabroersma@yahoo.com

almost 20 years ago

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.

surabhi.ahuja

surabhi.ahuja@iiitb.ac.in

almost 20 years ago

In reply to: Richard Broersma Jr (#1)

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@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,

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

Richard Broersma Jr

rabroersma@yahoo.com

almost 20 years ago

In reply to: surabhi.ahuja (#2)

Re: 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.

When I upgraded my system, I upgraded both PostgreSQL and libPQ to version 8.1.4. Before you
decide on anything be sure to read the 8.1 manual in the section regarding upgrading.

Regards,

Richard Broersma Jr.

surabhi.ahuja

surabhi.ahuja@iiitb.ac.in

almost 20 years ago

In reply to: Richard Broersma Jr (#3)

Re: planning to upgrade to 8.1

it is ok if i uninstall the current version of postgres 8.0.0

which i have done.

i am trying to install the rpms for 8.1.4 FC(4)
Where can i find the instaructions to download the rpms.

what i did was as follows,

1. instal the rpm postgresql-libs-8.1.4-1PGDG.i686.rpm
2. install the rpm postgresql-libs-8.1.4-1PGDG.i686.rpm

however this step was giving errors, some dependency errors

3. install the rpm postgresql-server-8.1.4-1PGDG.i686.rpm

is this not the way, i used to follw the above three steps to install 8.0.0 on my m/c.

thanks,
regards
Surabhi

________________________________

From: Richard Broersma Jr [mailto:rabroersma@yahoo.com]
Sent: Tue 6/27/2006 7:38 PM
To: surabhi.ahuja; pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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.

When I upgraded my system, I upgraded both PostgreSQL and libPQ to version 8.1.4. Before you
decide on anything be sure to read the 8.1 manual in the section regarding upgrading.

Regards,

Richard Broersma Jr.

Richard Broersma Jr

rabroersma@yahoo.com

almost 20 years ago

In reply to: surabhi.ahuja (#4)

Re: planning to upgrade to 8.1

it is ok if i uninstall the current version of postgres 8.0.0
which i have done.

Well before you do any un-installing you should read and understand:
http://www.postgresql.org/docs/8.1/interactive/install-upgrading.html

Regards,

Richard Broersma Jr.

Bruno Wolff III

bruno@wolff.to

almost 20 years ago

In reply to: surabhi.ahuja (#4)

Re: planning to upgrade to 8.1

On Tue, Jun 27, 2006 at 20:49:46 +0530,
"surabhi.ahuja" <surabhi.ahuja@iiitb.ac.in> wrote:

it is ok if i uninstall the current version of postgres 8.0.0

You need to dump you database(s) first unless you are upgrading to something
in the 8.0.x series.

Devrim GÜNDÜZ

devrim@gunduz.org

almost 20 years ago

In reply to: surabhi.ahuja (#4)

Re: planning to upgrade to 8.1

Hi,

On Tue, 2006-06-27 at 20:49 +0530, surabhi.ahuja wrote:

it is ok if i uninstall the current version of postgres 8.0.0

No. Please read this before you proceed:

http://pgfoundry.org/docman/?group_id=1000048

i am trying to install the rpms for 8.1.4 FC(4) Where can i find the
instaructions to download the rpms.

http://www.PostgreSQL.org/ftp/binary/v8.1.4/linux/rpms/fedora/fedora-core-4

what i did was as follows, 1. instal the rpm
postgresql-libs-8.1.4-1PGDG.i686.rpm 2. install the rpm
postgresql-libs-8.1.4-1PGDG.i686.rpm however this step was giving
errors, some dependency errors

I think you'll need this RPM also:

http://developer.postgresql.org/~devrim/rpms/compat/compat-postgresql-libs-3-3PGDG.i686.rpm

to satisfy some libpq dependencies.

Regards,
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

surabhi.ahuja

surabhi.ahuja@iiitb.ac.in

almost 20 years ago

In reply to: Richard Broersma Jr (#3)

error while installing the 8.1.4 rpms on my m/c

i have 4 rpms
i first install
compat-postgresql-libs-3-3PGDG.i686.rpm

then i install
postgresql-libs-8.1.4-1PGDG.i686.rpm

the i install
postgresql-8.1.4-1PGDG.i686.rpm

here i get an error it says

failed dependency
librealdline.so.5 is needed by postgresql-8.1.4-1PGDG.i686.rpm

what do i do?
thanks,
regards
Surabhi

________________________________

From: Devrim GUNDUZ [mailto:devrim@commandprompt.com]
Sent: Tue 6/27/2006 10:09 PM
To: surabhi.ahuja
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] planning to upgrade to 8.1

Hi,

On Tue, 2006-06-27 at 20:49 +0530, surabhi.ahuja wrote:

it is ok if i uninstall the current version of postgres 8.0.0

No. Please read this before you proceed:

http://pgfoundry.org/docman/?group_id=1000048

i am trying to install the rpms for 8.1.4 FC(4) Where can i find the
instaructions to download the rpms.

http://www.PostgreSQL.org/ftp/binary/v8.1.4/linux/rpms/fedora/fedora-core-4

what i did was as follows, 1. instal the rpm
postgresql-libs-8.1.4-1PGDG.i686.rpm 2. install the rpm
postgresql-libs-8.1.4-1PGDG.i686.rpm however this step was giving
errors, some dependency errors

I think you'll need this RPM also:

http://developer.postgresql.org/~devrim/rpms/compat/compat-postgresql-libs-3-3PGDG.i686.rpm

to satisfy some libpq dependencies.

Devrim GÜNDÜZ

devrim@gunduz.org

almost 20 years ago

In reply to: surabhi.ahuja (#8)

Re: error while installing the 8.1.4 rpms on my m/c

Hi,

On Wed, 2006-06-28 at 18:20 +0530, surabhi.ahuja wrote:

failed dependency librealdline.so.5 is needed by
postgresql-8.1.4-1PGDG.i686.rpm

yum install readline