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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Given, Robert A Sent: Friday, February 10, 2006 7:37 AM To: Tom Lane Cc: pgsql-admin@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxx] Sent: Friday, February 10, 2006 10:16 AM To: Given, Robert A Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Postgresql performance and tuning questions "Given, Robert A" <bgiven@xxxxxx> 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 **********************************************************************
