Thread: PostgreSQL 9.0 or 9.1 ?
Hello again! (i got my traditional email-address back!) we have been running our infrastructure on 8.3 for quite some years now, and i am thinking it is now time to upgrade all major parts of our system (java, jboss, postgresql). I would tend to be a little "radical" and go a little optimistic and greedy about it. I have been using 9.0 as a test system with no major flaws for quite some time as well. (but unfortunately without exploiting any of its new features) Till the end of July i must have finished all the migration to the new versions. The migration will involve testing of about 5,458 sql statements and the migration of some heavily customized in house functions, including a version of DBmirror (which is in use for a very specific set of problems) So i am asking what would be better from your perspective to do? Go for 9.1? or stick to 9.0 and try to deploy it and take the most out of it? When is a stable (release) version of 9.1 be available? Has any one faced any issues migrating from 9.0 to 9.1 -- Achilleas Mantzios
It could be worth considering 9.1. Probably by the time you get production ready version, 9.1 will be already stable (few months I guess). The usual answer to that question is - it will be ready when its ready.
On Thu, Jun 16, 2011 at 10:06 AM, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote: > Till the end of July i must have finished all the migration to the new versions. > > The migration will involve testing of about 5,458 sql statements and the > migration of some heavily customized in house functions, including > a version of DBmirror (which is in use for a very specific set of problems) You need to test these things on the exact version you plan to deploy, so not having a final 9.1 will make this pretty hard to do. Granted, the changes going in from now on are not supposed to be new/changed features, but just bug fixes... the final determination of how secure you feel in your testing is up to you.
> -----Original Message----- > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general- > owner@postgresql.org] On Behalf Of Grzegorz Jaskiewicz > Sent: Thursday, June 16, 2011 11:05 AM > To: Achilleas Mantzios > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] PostgreSQL 9.0 or 9.1 ? > > It could be worth considering 9.1. Probably by the time you get > production ready version, 9.1 will be already stable (few months I > guess). > The usual answer to that question is - it will be ready when its ready. > I would also ask, what is your (and your managements) tolerance for risk, and do you actually need any of the new featuresand/or performance benefits in 9.1? Postgres does have an excellent track record for quality and stability with new releases, but a couple of months in the fieldisn't really considered stable in most places. Brad.
On 06/16/2011 10:06 AM, Achilleas Mantzios wrote: > Till the end of July i must have finished all the migration to the new versions. > So i am asking what would be better from your perspective to do? > Go for 9.1? or stick to 9.0 and try to deploy it and take the most out of it? > When is a stable (release) version of 9.1 be available? > Has any one faced any issues migrating from 9.0 to 9.1 > I would place odds at about 1/3 that 9.1 will be available by the end of July. But you will still need to do testing of your application first before deploying onto that version. Realistically, even the earliest of 9.1 adopters is unlikely to launch before August. As such, there's not very much experience about the migration available yet, either. A large number of the new features in 9.1 aim at making certain types of development easier. The must-have features I am hearing demand for from my customers (who admittedly care more about replication and performance features than most), such that they are postponing some deployments until 9.1 ships because 9.0 just doesn't do what they want, are: -Synchronous replication -Support for MIN/MAX queries against partitioned tables -Feedback mechanism to reduce query conflict resolution when using Hot Standby -Much improved monitoring for replication and Hot Standby queries I'd suggest you take a look at the 9.1 release notes and beta announcement: http://www.postgresql.org/about/news.1313 , http://www.postgresql.org/docs/9.1/static/release-9-1.html And if you don't see a major compelling reason to wait for 9.1, some feature in that list that makes your life a lot easier, you really should just deploy 9.0 and move on. The most critical thing fixed in 9.1 development that may apply to what you're doing--some bug fixes to pg_upgrade--have all been backported to 9.0 now. -- Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
Thanx brad, i think 9.0 would be the most wise decision for the time being. Στις Thursday 16 June 2011 18:29:16 γράψατε: > > -----Original Message----- > > From: pgsql-general-owner@postgresql.org [mailto:pgsql-general- > > owner@postgresql.org] On Behalf Of Grzegorz Jaskiewicz > > Sent: Thursday, June 16, 2011 11:05 AM > > To: Achilleas Mantzios > > Cc: pgsql-general@postgresql.org > > Subject: Re: [GENERAL] PostgreSQL 9.0 or 9.1 ? > > > > It could be worth considering 9.1. Probably by the time you get > > production ready version, 9.1 will be already stable (few months I > > guess). > > The usual answer to that question is - it will be ready when its ready. > > > > I would also ask, what is your (and your managements) tolerance for risk, and do you actually need any of the new featuresand/or performance benefits in 9.1? > > Postgres does have an excellent track record for quality and stability with new releases, but a couple of months in thefield isn't really considered stable in most places. > > Brad. > -- Achilleas Mantzios