
{"id":4597,"date":"2023-10-25T04:49:48","date_gmt":"2023-10-25T04:49:48","guid":{"rendered":"https:\/\/test.opensource-db.in\/wp1\/?p=4597"},"modified":"2023-11-21T10:07:03","modified_gmt":"2023-11-21T10:07:03","slug":"bulk-loading-with-copy-postgres16","status":"publish","type":"post","link":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/","title":{"rendered":"Bulk loading with COPY in PostgreSQL 16"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\"><strong>Introduction:<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">At OpenSource DB, we work with Customers on various Data Engineering projects, and among the many critical aspects of data warehousing, the efficient and rapid movement of data is paramount. This is where PostgreSQL&#8217;s COPY feature shines. COPY is a versatile and high-performance utility that allows users to move data in and out of PostgreSQL quickly and effectively. When it comes to data warehousing, especially for tasks like bulk data loading or unloading, COPY is a game-changer. It provides a direct and efficient path for ingesting data from various sources into PostgreSQL tables or exporting data from these tables for further analysis. This feature significantly accelerates the ETL (Extract, Transform, Load) processes and enhances the overall performance and scalability of data warehousing solutions powered by PostgreSQL. Whether you&#8217;re dealing with terabytes of data or more, COPY simplifies the process and ensures that your data warehousing operations run smoothly.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">PostgreSQL has long been revered for its extensibility, reliability, and data integrity. With each new release, it evolves to meet the growing demands of modern applications. PostgreSQL 16, the latest iteration of this venerable open-source database management system, brings with it a transformative feature \u2014 Concurrent Bulk Loading. As per the PG16 release notes &#8220;This release includes improvements for bulk loading using <code>COPY<\/code> in both single and concurrent operations, with tests showing up to a 300% performance improvement in some cases.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This feature redefines the way you load massive amounts of data into your PostgreSQL database, promising improved performance, reduced downtime, and greater efficiency. In this blog, we&#8217;ll delve into the feature, understand how it works, and explore its implications for your PostgreSQL-powered applications.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here are a few PostgreSQL hackers&#8217; list discussions and commit link to understand the background work that went into the feature:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Discussion: <a href=\"https:\/\/www.postgresql.org\/message-id\/20221029025420.eplyow6k7tgu6he3%40awork3.anarazel.de\">https:\/\/www.postgresql.org\/message-id\/20221029025420.eplyow6k7tgu6he3%40awork3.anarazel.de<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Commit: <a href=\"https:\/\/git.postgresql.org\/gitweb\/?p=postgresql.git;a=commit;h=31966b151e6ab7a6284deab6e8fe5faddaf2ae4c\">https:\/\/git.postgresql.org\/gitweb\/?p=postgresql.git;a=commit;h=31966b151e6ab7a6284deab6e8fe5faddaf2ae4c<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Also, note that async I\/O won&#8217;t be included in PostgreSQL 16. While there were a couple of related patches, such as this one, it&#8217;s expected that Postgres 17 will be the first release to offer substantial and meaningful asynchronous I\/O benefits.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Summary of change:<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Today, when you&#8217;re adding data into a table and creating new pages in the table, each time that Postgres adds a new page it has to hold this relation extension lock. And there&#8217;s a lot of work that used to be done whilst holding that lock. As Andres describes in his mailing list thread, it\u2019s really way too much work while holding that lock. The refactoring work that Andres worked on in PostgreSQL 16 relates to reducing the time that the relation extension lock is held.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">While we&#8217;re on this topic, another PG16 feature enhancement that needs a mention is &#8220;<strong>Enhancements to storage<\/strong>&#8220;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The latest version brings a substantial enhancement (a threefold improvement for 16 clients) when performing concurrent COPY operations into a single relation. In this version, the relation extension lock is only held during the actual extension process. In contrast, in the previous version, the relation extension lock remained held while the system accomplished the following steps:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Acquired a victim buffer for the new page, which might entail further writing of the old page contents. This process could require flushing Write-Ahead Logging (WAL) as well.<\/li>\n\n\n\n<li>Wrote a zero page during the extension and then proceeded to write out the actual page contents. This additional step could almost double the write rate.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Now, let&#8217;s discuss a simple use case:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>-- Step 1: Data Preparation\n-- Assume you have a CSV file named 'sales_data.csv' prepared externally.\n\n-- Step 2: Initiating Bulk Load\n-- You can use the COPY command\nCOPY sales FROM '\/path\/to\/sales_data.csv' CSV HEADER;\n\n-- Step 3: Parallel Processing\n-- The data loading process is executed using multiple CPU cores, dramatically improving loading speed.\n\n-- Step 4: Avoiding Locks\n-- Concurrent queries and transactions can continue running without significant disruption.\n\n-- Step 5: Resource Management\n-- PostgreSQL intelligently manages system resources to prevent overuse during data loading.\n\n-- Step 6: Incremental Loading\n-- If desired, you can load data incrementally to avoid massive, time-consuming operations<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Each backend running COPY will report its progress in the <code>pg_stat_progress_copy<\/code> View<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A new COPY FROM \u2026 WITH introduced in PG16 is <code>DEFAULT 'default_string'<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>DEFAULT<\/strong><br>Specifies the string that represents a default value. Each time the string is found in the input file, the default value of the corresponding column will be used. This option is allowed only in COPY FROM, and only when not using binary format.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">To gauge the potential benefits of this feature with PostgreSQL 16, keep an eye on specific performance indicators during bulk loads with the COPY command. Monitor the &#8220;lock&#8221; wait event type and the subsequent &#8220;extend&#8221; lock wait event. If you find that these events are causing bottlenecks, you&#8217;ll observe that in your pg_stat_activity. The COPY operation, responsible for inserting data, will frequently show it&#8217;s busy with this type of wait event compared to others.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This observation will indicate a bottleneck associated with the particular &#8220;relation extend&#8221; lock. In PostgreSQL 16, you can anticipate an improvement of up to 300% in this regard.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction: At OpenSource DB, we work with Customers on various Data Engineering projects, and among the many critical aspects of [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":4598,"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":[90,26],"class_list":["post-4597","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql-14","category-postgresql-15","category-postgresql-16","tag-postgres16","tag-postgresql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Bulk loading with COPY in PostgreSQL 16 - 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=\"Bulk loading with COPY in PostgreSQL 16 - OpenSource DB\" \/>\n<meta property=\"og:description\" content=\"Introduction: At OpenSource DB, we work with Customers on various Data Engineering projects, and among the many critical aspects of [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/\" \/>\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-10-25T04:49:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-21T10:07:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1080\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Brahmini Ratnam\" \/>\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=\"Brahmini Ratnam\" \/>\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\/bulk-loading-with-copy-postgres16\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/\"},\"author\":{\"name\":\"Brahmini Ratnam\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/867a56696ebca29a93489ed53609f301\"},\"headline\":\"Bulk loading with COPY in PostgreSQL 16\",\"datePublished\":\"2023-10-25T04:49:48+00:00\",\"dateModified\":\"2023-11-21T10:07:03+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/\"},\"wordCount\":771,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#organization\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png\",\"keywords\":[\"postgres16\",\"postgresql\"],\"articleSection\":[\"PostgreSQL 14\",\"PostgreSQL 15\",\"PostgreSQL 16\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/\",\"name\":\"Bulk loading with COPY in PostgreSQL 16 - OpenSource DB\",\"isPartOf\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png\",\"datePublished\":\"2023-10-25T04:49:48+00:00\",\"dateModified\":\"2023-11-21T10:07:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#primaryimage\",\"url\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png\",\"contentUrl\":\"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png\",\"width\":1080,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/test.opensource-db.in\/wp1\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bulk loading with COPY in PostgreSQL 16\"}]},{\"@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\/867a56696ebca29a93489ed53609f301\",\"name\":\"Brahmini Ratnam\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/05bcc95d3352ddae501c8cdae6b20b8e4e59c373cb7e506042427bca7fe13a3b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/05bcc95d3352ddae501c8cdae6b20b8e4e59c373cb7e506042427bca7fe13a3b?s=96&d=mm&r=g\",\"caption\":\"Brahmini Ratnam\"},\"url\":\"https:\/\/test.opensource-db.in\/wp1\/author\/brahmini-ratnam-meruva\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Bulk loading with COPY in PostgreSQL 16 - 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":"Bulk loading with COPY in PostgreSQL 16 - OpenSource DB","og_description":"Introduction: At OpenSource DB, we work with Customers on various Data Engineering projects, and among the many critical aspects of [&hellip;]","og_url":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/","og_site_name":"OpenSource DB","article_publisher":"https:\/\/www.facebook.com\/people\/OpenSource-DB\/100072970755470\/","article_published_time":"2023-10-25T04:49:48+00:00","article_modified_time":"2023-11-21T10:07:03+00:00","og_image":[{"width":1080,"height":1080,"url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png","type":"image\/png"}],"author":"Brahmini Ratnam","twitter_card":"summary_large_image","twitter_creator":"@opensource_db","twitter_site":"@opensource_db","twitter_misc":{"Written by":"Brahmini Ratnam","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#article","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/"},"author":{"name":"Brahmini Ratnam","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/867a56696ebca29a93489ed53609f301"},"headline":"Bulk loading with COPY in PostgreSQL 16","datePublished":"2023-10-25T04:49:48+00:00","dateModified":"2023-11-21T10:07:03+00:00","mainEntityOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/"},"wordCount":771,"commentCount":0,"publisher":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#organization"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png","keywords":["postgres16","postgresql"],"articleSection":["PostgreSQL 14","PostgreSQL 15","PostgreSQL 16"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/","url":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/","name":"Bulk loading with COPY in PostgreSQL 16 - OpenSource DB","isPartOf":{"@id":"https:\/\/test.opensource-db.in\/wp1\/#website"},"primaryImageOfPage":{"@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#primaryimage"},"image":{"@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#primaryimage"},"thumbnailUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png","datePublished":"2023-10-25T04:49:48+00:00","dateModified":"2023-11-21T10:07:03+00:00","breadcrumb":{"@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#primaryimage","url":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png","contentUrl":"https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png","width":1080,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/test.opensource-db.in\/wp1\/bulk-loading-with-copy-postgres16\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/test.opensource-db.in\/wp1\/"},{"@type":"ListItem","position":2,"name":"Bulk loading with COPY in PostgreSQL 16"}]},{"@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\/867a56696ebca29a93489ed53609f301","name":"Brahmini Ratnam","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/test.opensource-db.in\/wp1\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/05bcc95d3352ddae501c8cdae6b20b8e4e59c373cb7e506042427bca7fe13a3b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/05bcc95d3352ddae501c8cdae6b20b8e4e59c373cb7e506042427bca7fe13a3b?s=96&d=mm&r=g","caption":"Brahmini Ratnam"},"url":"https:\/\/test.opensource-db.in\/wp1\/author\/brahmini-ratnam-meruva\/"}]}},"rttpg_featured_image_url":{"full":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",1080,1080,false],"landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",1080,1080,false],"portraits":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",1080,1080,false],"thumbnail":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2-150x150.png",150,150,true],"medium":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2-300x300.png",300,300,true],"large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2-1024x1024.png",1024,1024,true],"1536x1536":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",1080,1080,false],"2048x2048":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",1080,1080,false],"ultp_layout_landscape_large":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",800,800,false],"ultp_layout_landscape":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",570,570,false],"ultp_layout_portrait":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",600,600,false],"ultp_layout_square":["https:\/\/test.opensource-db.in\/wp1\/wp-content\/uploads\/2023\/10\/Blog-2.png",600,600,false]},"rttpg_author":{"display_name":"Brahmini Ratnam","author_link":"https:\/\/test.opensource-db.in\/wp1\/author\/brahmini-ratnam-meruva\/"},"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: At OpenSource DB, we work with Customers on various Data Engineering projects, and among the many critical aspects of [&hellip;]","_links":{"self":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4597","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\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/comments?post=4597"}],"version-history":[{"count":6,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4597\/revisions"}],"predecessor-version":[{"id":4852,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/posts\/4597\/revisions\/4852"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media\/4598"}],"wp:attachment":[{"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/media?parent=4597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/categories?post=4597"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/test.opensource-db.in\/wp1\/wp-json\/wp\/v2\/tags?post=4597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}