Earlier today (Oct 18, 2018), the PostgreSQL community announced the release of PostgreSQL 11. Having done multiple software releases earlier, I appreciate the hard work by all contributors to get yet another major release on schedule. It is hard to do a major release every year and the community has been doing it since PostgreSQL 8.4 making this the 10th release in the last decade.
Everybody has their favorite feature in PostgreSQL 11 and I have one that is top on my list which is the transactional support in stored procedures. 2nd Quadrant had first announced that feature end of last year and at that time, it instantly became my favorite as I see it as a giant leap in PostgreSQL as it allows people to essentially write long data routines like ETL broken down in multiple transactions. Of course many users will certainly enjoy the improvements in table partitioning system, query parallelism, and just-in-time (JIT) compilation for accelerating the execution of expressions in queries. However, the developers will certainly get more freedom with the stored procedure improvements.
With the release of PostgreSQL 11, now there are 6 major releases supported: PostgreSQL 9.3, 9.4, 9.5, 9.6, 10 and, 11. It is definitely a good time to start thinking to upgrade your PostgreSQL 9.3 databases. As per the versioning policy, the final minor release for PostgreSQL 9.3 will be on November 8th, 2018. PostgreSQL 9.3 will be the last major version which does not support logical replication which was first introduced in PostgreSQL 9.4. Hence, I expect this is will be the last painful upgrade because PostgreSQL 9.4 onwards you can always leverage logical replication to minimize the downtime while switching to a new version. All is not lost for PostgreSQL 9.3, while the experience is not exactly the same there are still tools available using the older trigger based replication to help or just bite the bullet and upgrade once with a small maintenance window as later versions will give you more options for your next major version upgrade.
If you need tips and tricks for upgrading your PostgreSQL 9.3 instances, let me know! :-)
21 comments:
Nice blog
AWS Training in Hyderabad
Best AWS Training in Hyderabad
I feel there is a need to find out which aspect of PostgreSQL is always useful and easier enough in order to replace the existing one.
SSIS Postgresql Write
this is great and capable post.
https://bolgameshowluckydraw.blogspot.com
I am so much impressed by your post.
https://cocacolaluckywinner1.blogspot.com
WEB Designing Services in Gurgaon
The blog is quite resourceful, however a touch of the professionals can diversity it even further. Our experts promise a fine quality all assignment The best experts in the business are here to take care of your academic needs.
Nice thanks for sharing informative post like this keep posting if like more details visit my website linkhttps://brollyacademy.com/azure-data-factory-training-in-hyderabad/
Your positivity is contagious! Thank you for spreading so much joy and happiness.
Embedded Linux Training In Hyderabad
This article provides valuable insights into the latest advancements in clinical health research and highlights the potential impact on patient care.
Clinical Trial Management
In the context of the provided post about PostgreSQL, we can explore how Power Automate development can be relevant to PostgreSQL database management and administration tasks. Power Automate development can be used to streamline and automate repetitive tasks associated with managing and working with PostgreSQL databases
Sirah Digital is a creative firm committed to assisting companies in realizing their goals. brand logo design A broad variety of digital services, including branding, website design, and digital marketing, are provided by our team of skilled experts.
"text blast" is a dynamic and efficient communication tool.
Nice blog
Thanks for sharing with us
Cloud Data Masters
Upgrade your career clinical data mange ment from industry experts gets complete hands on servicess, on our sclinbio.
I have been very impressed with the quality of the Whitehall Training courses. The content is well-presented and the instructors are knowledgeable and experienced. I would highly recommend Whitehall Training to anyone looking for training in the pharmaceutical industry." - Rinaldo Cavallo, Country Manager Italy, Scandinavia and Portugalwhitehall training
nice article
thanks for sharing with us
Orthodontist In Hyderabad
thanks for valuable information
ich gcp adapted for U.s
Integrating Power Automate with PostgreSQL simplifies database management by automating repetitive tasks, enhancing efficiency and productivity.
At Canapaks, a top-rated Canadian brand specializing in Himalayan Pink Salt and Turmeric Pills, using such tools ensures smooth operations and maintains our high standards of excellence.
Great news on PostgreSQL 11! Transactional support in stored procedures is a game-changer. At Recutify, an IT recruitment agency, we know how essential these advancements are for modern tech teams. For those on 9.3, it’s the perfect time to upgrade and enjoy features like logical replication for smoother transitions!
Post a Comment