Re: Postgresql performance and tuning questions

I do understand your school of thinking. But let me say this, from just
a user point of view who had used 7.4.x, 8.0, and 8.1, I'd highly
recommend to start off with 8.1. I can comment on performance in
particular among other great stuff such as scalability, robustness etc.
The performance in 8.1 compared with previous releases (even 8.0) is
remarkable and frankly like the difference between day and light,
specially when it comes to complex queries in large databases. From a
technical point of view, you can view the docs to find out more about
the great improvements with 8.1, such as
http://www.postgresql.org/docs/whatsnew

Just my two cents :)

----

Husam

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Given, Robert A
Sent: Friday, February 10, 2006 7:37 AM
To: Tom Lane
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgresql performance and tuning questions

Our philosophy is to use products that have been established, tested and
stable. We tend to not go with newer versions until they have time to
mature and have the bugs worked out. This is the version of the DB that
was packaged with the version of Linux we're using. So our thinking is
that we will go with that until we learn better. Our experience is more
with mainframes where habitually we proceed methodically. (That
translates to: slower than what we see with open source.)

Is there an impelling reason why we should migrate to a newer version
before we begin to use, observe, and experience Postgres of our own?

Thanks, Bob

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, February 10, 2006 10:16 AM
To: Given, Robert A
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgresql performance and tuning questions

"Given, Robert A" <bgiven(at)bu(dot)edu> writes:
> We are beginning a project to use Postgresql 7.4.2 on zLinux SLES9 The

> application of interest is uPortal 2.4.3.

Why are you not starting with a reasonably up-to-date version of
Postgres?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
**********************************************************************
This message contains confidential information intended only for the use of the addressee(s) named above and may contain information that is legally privileged. If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing or copying this message is strictly prohibited. If you have received this message by mistake, please immediately notify us by replying to the message and delete the original message immediately thereafter.

Thank you.

FADLD Tag
**********************************************************************