
{"id":2176,"date":"2021-10-08T07:29:27","date_gmt":"2021-10-08T07:29:27","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=2176"},"modified":"2021-10-08T07:32:13","modified_gmt":"2021-10-08T07:32:13","slug":"pg14-new-features-blog-series-part2","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/","title":{"rendered":"PostgreSQL 14 New Features \u2013 Part 2"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-style-default\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"340\" src=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1024x340.png\" alt=\"\" class=\"wp-image-2177\" srcset=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1024x340.png 1024w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-300x100.png 300w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-768x255.png 768w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1536x511.png 1536w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-2048x681.png 2048w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-298x99.png 298w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-241x80.png 241w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-394x131.png 394w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-915x304.png 915w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1240x412.png 1240w, https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1920x638.png 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">This is the second installment of 9-part Blog series talking about some of the PostgreSQL 14 New features.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the <a rel=\"noreferrer noopener\" href=\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part1\/\" data-type=\"URL\" data-id=\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part1\/\" target=\"_blank\">first part<\/a>, we discussed a few of the important System-level performance&nbsp;enhancements introduced in the PostgreSQL 14 major version. Mind you, the features discussed in the blog series are our most favourable ones and are being used in our daily activities. It goes without saying that PostgreSQL 14 came out with more than 200+ small, medium, large performance enhancements.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In this part, let&#8217;s delve into some of the interesting features around Data handling and modification performance enhancements.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We are a big fan of FOREIGN DATA WRAPPERs!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">So, it goes without saying, the first Data handling performance enhancement we are excited about is:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>postgres_fdw: Optimization of Bulk INSERT <\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">postgres_fdw can now also bulk insert data on foreign tables and import table partitions with the <a href=\"https:\/\/www.postgresql.org\/docs\/14\/sql-importforeignschema.html\" data-type=\"URL\" data-id=\"https:\/\/www.postgresql.org\/docs\/14\/sql-importforeignschema.html\" target=\"_blank\" rel=\"noreferrer noopener\">IMPORT FOREIGN SCHEMA<\/a> directive.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><em>What is a Foreign Data Wrapper?<\/em><br>PostgreSQL has a useful feature called Foreign Data Wrapper &#8211; FDWs, it is an extension that allows you to access a table or schema in one database from another. FDWs are part of SQL Standard called SQL\/MED (&#8220;SQL Management of External Data&#8221;) When you make a query against a foreign table, the Foreign Data Wrapper will query the external data source and return the results as if they were coming from a table in your database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">FDWs serve a variety of use-cases:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Customized Data Segregation:<\/strong> Data may be stored across databases (both PostgreSQL and few other supported RDBMs) and still have the visibility to Read\/Write data onto the FDWs.<br><\/li><li><strong>Data Security using ACL:<\/strong> It allows DBAs to come up with a customized Access control around the seggregated data.<br><\/li><li><strong>Heterogenous Data sources: <\/strong>Ability to perform aggregations from multiple data sources.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">To know more about the FDWs and the various Generic SQL Database and Specific Database Wrappers (like Oracle, MySQL) spend some time on <a rel=\"noreferrer noopener\" href=\"https:\/\/wiki.postgresql.org\/wiki\/Foreign_data_wrappers\" data-type=\"URL\" data-id=\"https:\/\/wiki.postgresql.org\/wiki\/Foreign_data_wrappers\" target=\"_blank\">Postgres Wiki for FDWs<\/a>.<\/p>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let&#8217;s look at the Bulk INSERT performance optimization. This feature of <strong>postgres_fdw<\/strong> is added to the PostgreSQL Core.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The key to this feature is using the remote option &#8220;<strong>batch_size<\/strong>&#8220;<br>batch_size specifies the number of rows postgres_fdw should insert in each insert operation. It can be specified for a foreign table or a foreign server. The option specified on a table overrides an option specified for the server.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">An example to create a FOREIGN TABLE or FOREIGN SERVER:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>--Foreign server\n\nCREATE SERVER postgres_fdw_server01\n   FOREIGN DATA WRAPPER postgres_fdw\n   OPTIONS (host 'xx.xx.xx.xx', batch_size = '50'); -- this is the new option\n\n--Foreign table\n\nCREATE FOREIGN TABLE my_remote_table (\n\tcol1 integer,\n    col2 char,\n    col3 text,\n    )\nSERVER postgres_fdw_server01 OPTIONS(table_name 'my_local_table', batch_size '50');\n\n<\/code><\/pre>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>FDW Support for TRUNCATE<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">We now have a new option with FDW API for TRUNCATE. It extends TRUNCATE command so that it accepts foreign tables as the target to truncate and invokes that API. So, when using postgres_fdw, we can issue TRUNCATE command to foreign servers\/tables.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A quick example using the Foreign table created in the above code:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>TRUNCATE my_remote_table;<\/code><\/pre>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Handling UPDATEs and DELETEs<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Before delving into the actual performance enhancement around the planner changes to UPDATEs and DELETEs, Let&#8217;s look at an important point from the <a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.org\/docs\/14\/transaction-iso.html#XACT-READ-COMMITTED\" data-type=\"URL\" data-id=\"https:\/\/www.postgresql.org\/docs\/14\/transaction-iso.html#XACT-READ-COMMITTED\" target=\"_blank\">PostgreSQL documentation<\/a>:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><code>UPDATE<\/code>,&nbsp;<code>DELETE<\/code>,&nbsp;<code>SELECT FOR UPDATE<\/code>, and&nbsp;<code>SELECT FOR SHARE<\/code>&nbsp;commands behave the same as&nbsp;<code>SELECT<\/code>&nbsp;in terms of searching for target rows: they will only find target rows that were committed as of the command start time. However, such a target row might have already been updated (or deleted or locked) by another concurrent transaction by the time it is found. In this case, the would-be updater will wait for the first updating transaction to commit or roll back (if it is still in progress). If the first updater rolls back, then its effects are negated and the second updater can proceed with updating the originally found row. If the first updater commits, the second updater will ignore the row if the first updater deleted it, otherwise it will attempt to apply its operation to the updated version of the row. The search condition of the command (the&nbsp;<code>WHERE<\/code>&nbsp;clause) is re-evaluated to see if the updated version of the row still matches the search condition. If so, the second updater proceeds with its operation using the updated version of the row. In the case of&nbsp;<code>SELECT FOR UPDATE<\/code>&nbsp;and&nbsp;<code>SELECT FOR SHARE<\/code>, this means it is the updated version of the row that is locked and returned to the client.<\/p><\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\"><em>Always remember that the UPDATE does not update the tuples in place, it INSERTs a new version of the tuple and leaves a dead tuple for VACUUM to later removal.<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Now, for the planner changes to fasten UPDATE and DELETE:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>For UPDATE, the subplan now only delivers the new values of the changed columns (i.e., the expressions computed in the query&#8217;s SET clause) plus row identity information such as CTID.<br><\/li><li>For inherited UPDATE\/DELETE, instead of generating a separate subplan for each target relation, we now generate a single subplan that is just exactly like a SELECT&#8217;s plan, then update the table on top of that.<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Take a look at the commit message of <a href=\"https:\/\/git.postgresql.org\/gitweb\/?p=postgresql.git;a=commit;h=86dc90056d\" data-type=\"URL\" data-id=\"https:\/\/git.postgresql.org\/gitweb\/?p=postgresql.git;a=commit;h=86dc90056d\" target=\"_blank\" rel=\"noreferrer noopener\">Rework planning and execution of UPDATE and DELETE<\/a> for more code-level changes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In our next part tomorrow, we\u2019ll discuss the Performance enhancements and features specifically optimizing the worldloads.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Stay tuned!!!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is the second installment of 9-part Blog series talking about some of the PostgreSQL 14 New features. In the [&hellip;]<\/p>\n","protected":false},"author":3,"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],"tags":[28,27,29,24],"class_list":["post-2176","post","type-post","status-publish","format-standard","hentry","category-postgresql-14","tag-major-release","tag-new-features","tag-performance","tag-postgres14"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL 14 New Features \u2013 Part 2 - 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=\"PostgreSQL 14 New Features \u2013 Part 2 - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"This is the second installment of 9-part Blog series talking about some of the PostgreSQL 14 New features. In the [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/\" \/>\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=\"2021-10-08T07:29:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-08T07:32:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1024x340.png\" \/>\n<meta name=\"author\" content=\"Hari Kiran\" \/>\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=\"Hari Kiran\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/pg14-new-features-blog-series-part2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/\"},\"author\":{\"name\":\"Hari Kiran\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/2d16bf6a94c0502f1c5b69e4a36e9a09\"},\"headline\":\"PostgreSQL 14 New Features \u2013 Part 2\",\"datePublished\":\"2021-10-08T07:29:27+00:00\",\"dateModified\":\"2021-10-08T07:32:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/\"},\"wordCount\":852,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1024x340.png\",\"keywords\":[\"major-release\",\"new-features\",\"performance\",\"postgres14\"],\"articleSection\":[\"PostgreSQL 14\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/\",\"name\":\"PostgreSQL 14 New Features \u2013 Part 2 - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1024x340.png\",\"datePublished\":\"2021-10-08T07:29:27+00:00\",\"dateModified\":\"2021-10-08T07:32:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2.png\",\"width\":3200,\"height\":1064},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL 14 New Features \u2013 Part 2\"}]},{\"@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\/2d16bf6a94c0502f1c5b69e4a36e9a09\",\"name\":\"Hari Kiran\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c9afef742ba871448bf401518655463f5e87b02f9fbd0096e88f857c51896822?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c9afef742ba871448bf401518655463f5e87b02f9fbd0096e88f857c51896822?s=96&d=mm&r=g\",\"caption\":\"Hari Kiran\"},\"description\":\"Hari Kiran has over 15 years of extensive experience in areas of operations and managing multiple database technologies. A proven leader with excellent skills in building relationships, positive team dynamics, and decision-making. Hari also has strong Open Source expertise in Professional Services. He has the experience to help you refine your strategy and drive execution.\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/harikiranopensource-db-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL 14 New Features \u2013 Part 2 - 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":"PostgreSQL 14 New Features \u2013 Part 2 - OpenSource DB","og_description":"This is the second installment of 9-part Blog series talking about some of the PostgreSQL 14 New features. In the [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2021-10-08T07:29:27+00:00","article_modified_time":"2021-10-08T07:32:13+00:00","og_image":[{"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1024x340.png","type":"","width":"","height":""}],"author":"Hari Kiran","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Hari Kiran","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/"},"author":{"name":"Hari Kiran","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/2d16bf6a94c0502f1c5b69e4a36e9a09"},"headline":"PostgreSQL 14 New Features \u2013 Part 2","datePublished":"2021-10-08T07:29:27+00:00","dateModified":"2021-10-08T07:32:13+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/"},"wordCount":852,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1024x340.png","keywords":["major-release","new-features","performance","postgres14"],"articleSection":["PostgreSQL 14"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/","url":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/","name":"PostgreSQL 14 New Features \u2013 Part 2 - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2-1024x340.png","datePublished":"2021-10-08T07:29:27+00:00","dateModified":"2021-10-08T07:32:13+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2021\/10\/ps14-blog-day-2.png","width":3200,"height":1064},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/pg14-new-features-blog-series-part2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL 14 New Features \u2013 Part 2"}]},{"@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\/2d16bf6a94c0502f1c5b69e4a36e9a09","name":"Hari Kiran","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c9afef742ba871448bf401518655463f5e87b02f9fbd0096e88f857c51896822?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c9afef742ba871448bf401518655463f5e87b02f9fbd0096e88f857c51896822?s=96&d=mm&r=g","caption":"Hari Kiran"},"description":"Hari Kiran has over 15 years of extensive experience in areas of operations and managing multiple database technologies. A proven leader with excellent skills in building relationships, positive team dynamics, and decision-making. Hari also has strong Open Source expertise in Professional Services. He has the experience to help you refine your strategy and drive execution.","url":"https:\/\/test.opensource-db.in\/wp1\/author\/harikiranopensource-db-com\/"}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"Hari Kiran","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/harikiranopensource-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>","rttpg_excerpt":"This is the second installment of 9-part Blog series talking about some of the PostgreSQL 14 New features. In the [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/2176","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=2176"}],"version-history":[{"count":12,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/2176\/revisions"}],"predecessor-version":[{"id":2189,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/2176\/revisions\/2189"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=2176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=2176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=2176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}