{"id":14646,"date":"2025-09-25T19:16:13","date_gmt":"2025-09-25T10:16:13","guid":{"rendered":"https:\/\/aireviewirush.com\/?p=14646"},"modified":"2025-09-25T19:16:13","modified_gmt":"2025-09-25T10:16:13","slug":"the-very-best-new-options-in-postgres-18","status":"publish","type":"post","link":"https:\/\/aireviewirush.com\/?p=14646","title":{"rendered":"The very best new options in Postgres 18"},"content":{"rendered":"<p> <br \/>\n<br \/><img decoding=\"async\" src=\"https:\/\/www.infoworld.com\/wp-content\/uploads\/2025\/09\/4062619-0-65035800-1758790941-elephant_desert_tusk_ivory_postgresql-100775617-orig.jpg?quality=50&amp;strip=all\" alt=\"\"><\/p>\n<div>\n<ul class=\"wp-block-list\">\n<li>Centralizing credential administration<\/li>\n<li>Enabling scalable, role-based entry management<\/li>\n<li>Strengthening safety posture with standards-based authentication<\/li>\n<\/ul>\n<p>Postgres 18 additionally contains further safety enhancements. This model deprecates MD5 and permits SCRAM authentication in new places, together with connections to different databases through international knowledge wrappers, strengthening safety throughout distributed environments.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_53 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\" role=\"button\"><label for=\"item-6a293a1aa3db5\" ><span class=\"\"><span style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input aria-label=\"Toggle\" aria-label=\"item-6a293a1aa3db5\"  type=\"checkbox\" id=\"item-6a293a1aa3db5\"><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/aireviewirush.com\/?p=14646\/#Advancing_SQL_requirements_Extra_flexibility_for_contemporary_purposes\" title=\"Advancing SQL requirements: Extra flexibility for contemporary purposes\">Advancing SQL requirements: Extra flexibility for contemporary purposes<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/aireviewirush.com\/?p=14646\/#Optimizer_enhancements_Smarter_question_planning_with_much_less_developer_tuning\" title=\"Optimizer enhancements: Smarter question planning with much less developer tuning\">Optimizer enhancements: Smarter question planning with much less developer tuning<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"advancing-sql-standards-more-flexibility-for-modern-applications\"><span class=\"ez-toc-section\" id=\"Advancing_SQL_requirements_Extra_flexibility_for_contemporary_purposes\"><\/span>Advancing SQL requirements: Extra flexibility for contemporary purposes<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Postgres 18 introduces new enhancements for NOT NULL constraints, international keys, and digital generated columns, bettering knowledge integrity and giving builders extra choices when constructing purposes that have to run throughout a number of database platforms. These updates make it simpler to make use of Postgres as the inspiration for standards-based purposes\u2014an necessary benefit for groups that need portability and long-term maintainability.<\/p>\n<h2 class=\"wp-block-heading\" id=\"optimizer-improvements-smarter-query-planning-with-less-developer-tuning\"><span class=\"ez-toc-section\" id=\"Optimizer_enhancements_Smarter_question_planning_with_much_less_developer_tuning\"><\/span>Optimizer enhancements: Smarter question planning with much less developer tuning<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>For a few years, the Postgres question optimizer noticed solely modest modifications, however latest releases have reversed that pattern. In Postgres 18, builders will see:<\/p>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"<p>Centralizing credential administration Enabling scalable, role-based entry management Strengthening safety posture with standards-based authentication Postgres 18 additionally contains further safety enhancements. This model deprecates MD5 and permits SCRAM authentication in new places, together with connections to different databases through international knowledge wrappers, strengthening safety throughout distributed environments. Advancing SQL requirements: Extra flexibility for contemporary purposes [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":14648,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20],"tags":[],"class_list":["post-14646","post","type-post","status-publish","format-standard","has-post-thumbnail","category-cloud-computing"],"_links":{"self":[{"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/posts\/14646","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14646"}],"version-history":[{"count":1,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/posts\/14646\/revisions"}],"predecessor-version":[{"id":14647,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/posts\/14646\/revisions\/14647"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=\/wp\/v2\/media\/14648"}],"wp:attachment":[{"href":"https:\/\/aireviewirush.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/aireviewirush.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}