
{"id":4490,"date":"2023-09-27T07:50:18","date_gmt":"2023-09-27T07:50:18","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=4490"},"modified":"2023-10-04T09:18:47","modified_gmt":"2023-10-04T09:18:47","slug":"unleashing-pg16-new-features-blog-series","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/","title":{"rendered":"Unleashing PG16 New Features &#8211; Blog series"},"content":{"rendered":"\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"535\" data-id=\"4500\" src=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-1024x535.png\" alt=\"\" class=\"wp-image-4500\" srcset=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-1024x535.png 1024w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-300x157.png 300w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-768x401.png 768w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-189x99.png 189w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-153x80.png 153w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-394x206.png 394w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-915x478.png 915w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1.png 1200w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Introduction:<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">In the ever-evolving world of relational databases, PostgreSQL continues to shine as a beacon of innovation and reliability. With each new release, it unveils a treasure trove of features that cater to the needs of modern applications and enterprises. PostgreSQL 16, the latest installment in this remarkable journey, promises to be no different. Packed with enhancements and capabilities, it sets the stage for a more powerful, efficient, and user-friendly database management experience. In this blog post, we embark on a thrilling journey to explore some of the most exciting features that PostgreSQL 16 brings to the table. From performance improvements to advanced data processing, and everything in between, join us as we unveil the future of PostgreSQL.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We\u2019ll be doing a series of blogs around the super cool features introduced in PG16 and some of the features enhanced in PG16.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To start with, one of the most important ones in our view is the ability to perform logical replication from the standby node, which we discuss below.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Logical replication from a physical standby instance<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">At a broad level, PostgreSQL offers support for two primary types of replication: streaming\/physical replication and logical replication. Streaming\/physical replication involves transmitting the entire collection of physical files over a connection, effectively replicating the entire on-disk database. In contrast, logical replication provides a more granular approach, allowing you to specify specific database objects, be it tables or even individual rows, for replication to a remote server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One notable benefit of logical replication is its capability to subscribe to changes from PostgreSQL servers across various versions! This flexibility proves invaluable when dealing with applications that employ different versions of PostgreSQL. Now, we can setup a Logical replica from the readonly Physical standby PostgreSQL instance seamlessly. This operation would previously fail before Postgres 16 (screenshot below).<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Data can be filtered based on origin during replication.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>In primary:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE PUBLICATION mypub FOR ALL TABLES;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>In Standby:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Perform the operation on standby if the server running on pg 15 you will get the below error:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/-EVkpkI6XqZDOiQ6euVkeoRa2_iEnC7l_Vb7EjuuACBMHE0ZisjETpdI8pfwcB2d7faGxCv9z7mBvNt4W4Yzd1uLsmwKuwtjOiHNb-nF2cDrkorrHiTHygIRS8enOuEo16Z1bK3HrgVWDGQMAfgmi5U\" width=\"624\" height=\"116\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Perform the operation on pg 16:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>osdb=# CREATE SUBSCRIPTION mysub_standby \nCONNECTION 'host=192.168.113.209 port=5432 user=repuser password=postgres dbname=osdb'\nPUBLICATION mypub WITH (origin = none);\nNOTICE:  created replication slot \"mysub_standby\" on publisher\nCREATE SUBSCRIPTION<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"629\" height=\"57\" src=\"https:\/\/lh3.googleusercontent.com\/fug4rp-PAolQARaUy6_6zJw80yMX2qI-AqvJuLzw3kUtUEEW1uGUj_eCGP6d33MmIHQ3AQGQRBYva0zmcOsNlNhruzrFCapoF-GO4Jma_JwhIC6mdeWMCyrt4ULK-CfvChvS4QfHBVhdSMUaoHaSK5g\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Postgres 16, setting a bi-directional or logical replication among nodes was difficult, because if we set up replication for a table, it would lead to an infinite loop. By adding the ability to filter data based on origin, we can set up n-way logical replication, and that will prevent loops when performing bi-directional replication.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Logical replication parallel apply of transactions:<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Large transactions can be applied in parallel.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>osdb=# CREATE SUBSCRIPTION mysub_streming_parallel\nCONNECTION 'host=192.168.113.209 port=5432 user=repuser password=postgres dbname=osdb'\nPUBLICATION mypub WITH (streaming = parallel);\nNOTICE:  created replication slot \"mysub_streming_parallel\" on publisher\nCREATE SUBSCRIPTION\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/aJCfu_m0IPEwr-bH2EPGXx-CzV5jv-cWgbUtUw1kbP3-nYMvbMphSppDYUprYjjHXiH4lQf-h3CHCXAgc8CUb9b8wIVus9nQgSM8P5azckYhP1NqF4mUc6nZOH85imQ4j0PNEZB_3oqs6DQCAWfoc3E\" width=\"624\" height=\"76\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Performance improvement in the range of 25-40% has been observed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each large transaction is assigned to one of the available workers, which improves lag by immediately applying instead of waiting till the whole transaction is received by the subscriber. The worker remains assigned until the transaction is completed.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><code>max_parallel_apply_workers_per_subscription<\/code> sets the maximum number of parallel apply workers per subscription.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>osdb=# show max_parallel_apply_workers_per_subscription ;\nmax_parallel_apply_workers_per_subscription\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" width=\"478\" height=\"91\" src=\"https:\/\/lh3.googleusercontent.com\/tHe4SgxM7XwRcDM7ogdJtaaTGTXGQ35PiMHY4-JoGr-SUIHcjfbXQnS_Dh_u35q3gFnXKtwCXL44FT1NVeTKeVWxXrNoslzit0APJGhf6kJQSSpIcF7AL0JIiZ5JoddyY8R_NlKJuefPxIOfbXVVIXU\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">              ***      ***      ***      ***      ***      ***      ***      ***      ***      ***      ***     <\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>The apply process can be configured to perform operations with the table owner&#8217;s privileges instead of the subscription owner&#8217;s privileges.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Perform the operation on pg 16:<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE SUBSCRIPTION mysub_standby_2\nCONNECTION 'host=192.168.113.209 port=5432 user=repuser dbname=osdb'\nPUBLICATION mypub WITH (run_as_owner = false);\nCREATE SUBSCRIPTION\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/J52w4puCOEKES7M38521sgO1nqpwyzyAQ2rIC76akgPoDY5LHJdUBurdCqoemZ_pSADmj3OJ9l5gapac9BKHzYwbvkAZ5oSJJueSDILG_AEXK2HstjPrU5P2qHeJfp2dHPyvsBOnp1U1_q03wTI2v_U\" width=\"624\" height=\"77\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Non-superusers can create subscriptions.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The non-superusers must have been granted a pg_create_subscription role, and are required to specify a password for authentication.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Superusers can set password_required = false for non-superusers who own the subscription.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>A monitoring boon &#8211; pg_stat_io<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The &#8220;pg_stat_io&#8221; is a system view in PostgreSQL that provides statistics about input and output (I\/O) operations at the database level. It can be used to monitor and analyze the I\/O activity of your PostgreSQL database, which can be valuable for performance tuning and troubleshooting.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL 16 records statistics on the last sequential and index scans on tables, adds speculative lock information to the pg_locks view and makes several improvements to wait events that make monitoring of PostgreSQL more comprehensive than ever.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">New pg_stat_io view: Offering comprehensive I\/O statistics for troubleshooting performance issues and database optimization. With this view in place, we&#8217;ll be able to:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Monitoring system-wide buffer cache hit ratio calculation precisely<\/li>\n\n\n\n<li>Accumulating system-wide I\/O times, providing a comprehensive view beyond the existing I\/O counts in pg_stat_io.<\/li>\n\n\n\n<li>Enhancing cumulative WAL statistics, surpassing the capabilities of pg_stat_wal.<\/li>\n\n\n\n<li>Expanding I\/O tracking to include tables and indexes, offering a more comprehensive overview.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Here is an example of the statistics you can see in pg_stat_io as following:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img loading=\"lazy\" decoding=\"async\" width=\"624\" height=\"213\" src=\"https:\/\/lh3.googleusercontent.com\/zggkgd02EyamL0sGxAVFhck6ZzhJg8fn9LJwooaNjjAE3DVt-qxLDicdJwDl-pHGUjmOhE-fcuTKtckXip2pEOf5ul6KjFE-r3l9ruCB1cxH1w86gfqbdIFkilxZXLiIY-8ODNVD7mXbl3SE3bousFYmfm2yriLM\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">As we continue this exploration of PostgreSQL 16&#8217;s exciting new features, we&#8217;ve only looked at the Logical replication features in this blog post. From performance enhancements to improved data management and security features, PostgreSQL 16 is set to empower developers, administrators, and businesses alike. In our next blog post, we&#8217;ll dive deeper into specific use cases and practical examples to showcase how these features can transform your database operations. Stay tuned for more insights into the world of PostgreSQL 16!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: In the ever-evolving world of relational databases, PostgreSQL continues to shine as a beacon of innovation and reliability. With [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[23,42,89],"tags":[27,26],"class_list":["post-4490","post","type-post","status-publish","format-standard","hentry","category-postgresql-14","category-postgresql-15","category-postgresql-16","tag-new-features","tag-postgresql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Unleashing PG16 New Features - Blog series - OpenSource DB<\/title>\n<meta name=\"robots\" content=\"noindex, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unleashing PG16 New Features - Blog series - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction: In the ever-evolving world of relational databases, PostgreSQL continues to shine as a beacon of innovation and reliability. With [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/\" \/>\n<meta property=\"og:site_name\" content=\"OpenSource DB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-09-27T07:50:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-04T09:18:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-1024x535.png\" \/>\n<meta name=\"author\" content=\"Venkat Akhil\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:site\" content=\"@opensource_db\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Venkat Akhil\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/\"},\"author\":{\"name\":\"Venkat Akhil\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\"},\"headline\":\"Unleashing PG16 New Features &#8211; Blog series\",\"datePublished\":\"2023-09-27T07:50:18+00:00\",\"dateModified\":\"2023-10-04T09:18:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/\"},\"wordCount\":796,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-1024x535.png\",\"keywords\":[\"new-features\",\"postgresql\"],\"articleSection\":[\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/\",\"name\":\"Unleashing PG16 New Features - Blog series - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-1024x535.png\",\"datePublished\":\"2023-09-27T07:50:18+00:00\",\"dateModified\":\"2023-10-04T09:18:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1.png\",\"width\":1200,\"height\":627},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Unleashing PG16 New Features &#8211; Blog series\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"name\":\"OpenSource DB\",\"description\":\"Your Trusted OpenSource Databases partner\",\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\",\"name\":\"OPENSOURCE DB PRIVATE LIMITED\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png\",\"width\":368,\"height\":120,\"caption\":\"OPENSOURCE DB PRIVATE LIMITED\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/\",\"https:\/\/x.com\/opensource_db\",\"https:\/\/www.youtube.com\/channel\/UCmTI5h\",\"https:\/\/www.linkedin.com\/company\/opensource-db\",\"https:\/\/www.instagram.com\/opensource_db\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328\",\"name\":\"Venkat Akhil\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g\",\"caption\":\"Venkat Akhil\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Unleashing PG16 New Features - Blog series - OpenSource DB","robots":{"index":"noindex","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"og_locale":"en_US","og_type":"article","og_title":"Unleashing PG16 New Features - Blog series - OpenSource DB","og_description":"Introduction: In the ever-evolving world of relational databases, PostgreSQL continues to shine as a beacon of innovation and reliability. With [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2023-09-27T07:50:18+00:00","article_modified_time":"2023-10-04T09:18:47+00:00","og_image":[{"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-1024x535.png","type":"","width":"","height":""}],"author":"Venkat Akhil","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Venkat Akhil","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/"},"author":{"name":"Venkat Akhil","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328"},"headline":"Unleashing PG16 New Features &#8211; Blog series","datePublished":"2023-09-27T07:50:18+00:00","dateModified":"2023-10-04T09:18:47+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/"},"wordCount":796,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-1024x535.png","keywords":["new-features","postgresql"],"articleSection":["PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/","url":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/","name":"Unleashing PG16 New Features - Blog series - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1-1024x535.png","datePublished":"2023-09-27T07:50:18+00:00","dateModified":"2023-10-04T09:18:47+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/09\/pg16-new-features-blog-image1.png","width":1200,"height":627},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/unleashing-pg16-new-features-blog-series\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Unleashing PG16 New Features &#8211; Blog series"}]},{"@type":"WebSite","@id":"https:\/\/test.opensource-db.in\/wp1\/#website","url":"https:\/\/test.opensource-db.in\/wp1\/","name":"OpenSource DB","description":"Your Trusted OpenSource Databases partner","publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/test.opensource-db.in\/wp1\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/test.opensource-db.in\/wp1\/#organization","name":"OPENSOURCE DB PRIVATE LIMITED","url":"https:\/\/test.opensource-db.in\/wp1\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/osdb-logo-tm-2.png","width":368,"height":120,"caption":"OPENSOURCE DB PRIVATE LIMITED"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","https:\/\/x.com\/opensource_db","https:\/\/www.youtube.com\/channel\/UCmTI5h","https:\/\/www.linkedin.com\/company\/opensource-db","https:\/\/www.instagram.com\/opensource_db\/"]},{"@type":"Person","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/a37b142ecbf953189a4f9209b0b8d328","name":"Venkat Akhil","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/522c0947d21b2c2c89f10698fd9131f9db4110f65c8d02b53d9b4559c7650865?s=96&d=mm&r=g","caption":"Venkat Akhil"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"Venkat Akhil","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/sudheer-sopensource-db-com\/"},"rttpg_comment":0,"rttpg_category":"<a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-14\/\" rel=\"category tag\">PostgreSQL 14<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-15\/\" rel=\"category tag\">PostgreSQL 15<\/a> <a href=\"https:\/\/test.opensource-db.in\/wp1\/category\/postgres\/postgresql-16\/\" rel=\"category tag\">PostgreSQL 16<\/a>","rttpg_excerpt":"Introduction: In the ever-evolving world of relational databases, PostgreSQL continues to shine as a beacon of innovation and reliability. With [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4490","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=4490"}],"version-history":[{"count":8,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4490\/revisions"}],"predecessor-version":[{"id":4501,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4490\/revisions\/4501"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=4490"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=4490"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=4490"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}