Postgresql has released RC1 for Postgresql 9.4:
and are expecting to release a GM within Dec 2014/Jan 2015 as far as I can tell from their website. I have been running a development machine on Postgresql 9.4 (dev branch) with Odoo 8.0 for awhile now and have not noticed any issues with Odoo's functionality due to the database.
My question is will Postgresql 9.4 be officially endorsed/compatible with Odoo 8.0/Master? I'm interested in installing a development machine for testing as soon as the GM is released to the public as it offers better perforance than the 9.3 version and has a huge number of other features that could be utilised by developers in Odoo implementations.
From what I can tell from the development branch I have been testing on there is no compatibility issues, however it would be great to have an official statement from Odoo as to whether 9.4 will be supported in 8.0/Master once the GM is released.
Since I've been testing with postgreSQL 9.3 and 9.4 a lot the last days I decided it is time for me to write out a comment.
The question about if 9.4 will be officialy added to Odoo 8 (or maybe 9) as compatible I'm not sure. At this point nobody can say this because this is something Odoo will need to decide and they should release the choice to the public.
I'd think they would first need to do intensive testing for this and also look at speeds. Then there is a second option: will they choose to say that it is supported or will they choose to say this is the preffered version. This will all come down to performance probably.
And because performance is they key I've been testing a bit around with Odoo. I'vet setup two identical machines with identical databases. The only difference is that one version runs postgreSQL V9.3 and one runs postgreSQL V9.4.
To test this I've simply installed half a dozen of modules, added some data in it and simply tested both versions with timers.
The result was a bit dissapointing though. Turned out V9.3 was a tiny bit faster than V9.4.. As you can see in this graph:
The times are in seconds and as you can see every time there was just a silght difference, four out of five times in favour of V9.3.
Despite that V9.3 and V9.4 barely having a difference I do seem to notice better performance when you click on menu items etc.
It seems that V9.4 is slightly faster with loading data when the user clicks through items and does menu-actions. But I'm not sure how I could prove that in statistics as it takes milliseconds really.
In terms of compatibility it seems that postgreSQL V9.4 is fully compatible with Odoo V8. I've tested a few databases, options, reloads, ... and nothing seemed wrong. So I assume we will need to wait for an official statement from Odoo about this but I see no reason why they wouldn't be officially compatible.
Update: Because I saw that Luke added a comment about the tuning on your postgreSQL (as seen in this topic: https://www.odoo.com/forum/help-1/question/how-to-tune-postgresql-for-openerp-v7-production-environment-25326) I decided to give this a try too. After implementing these modifications I experienced a slight speed increase. Every Odoo restart with a full update of all modules would win me between 3 to 6 seconds. While this is a not a gigantic difference it could perhaps help other people that are in a huge environment.
I guess there will be no problem with new versions of poestgres database , because odoo does not use advaces psql functions that comes with new versions.. It works on 9.2 and 9.3 flowless, and upgrading to 9.4 or any future version will change nothing...
No need to worry about new versions of db.. just use it...
will work fine
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 12/15/14, 1:25 AM|
|Seen: 4456 times|
|Last updated: 10/21/15, 5:36 AM|