{"id":14731,"date":"2020-01-13T07:08:59","date_gmt":"2020-01-13T07:08:59","guid":{"rendered":"https:\/\/dbtut.com\/?p=14731"},"modified":"2020-01-13T07:09:00","modified_gmt":"2020-01-13T07:09:00","slug":"how-to-create-partition-on-jsonb-column-in-postgresql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/","title":{"rendered":"How To Create Partition on JSONB column in PostgreSQL"},"content":{"rendered":"<p>I will share an example that creates partition on JSONB column in PostgreSQL in this article. But first we need to know What JSON and JSONB are.<\/p>\n<h2>What is JSON and JSONB?<\/h2>\n<p>JSON and JSONB data types are available in PostgreSQL to store JSON data. Json stores data as a string and parses each query.<\/p>\n<p>JSONB parses json and saves it in binary format. In such columns, the writing speed is slow, but the reading speed is quite fast.<\/p>\n<p>JSON is an indispensable language for those who develop web applications, JavaScript, and REST-based mobile application. We said it is a language, but JSON is actually a data interchange format.<\/p>\n<p>In PostgreSQL 9.4, the JSONB data type support(the binary version of JSON) was introduced.<\/p>\n<p>Up to this point, we have tried to understand the JSON and JSONB data types.<\/p>\n<h3>So how do we create partition on JSONB columns?<\/h3>\n<pre class=\"lang:default decode:true\">--Create table that has JSONB column.\nCREATE TABLE jsonBDemo (data jsonb) partition by range ((data-&gt;'id'));\n \n--Specify Partitions.\nCREATE TABLE jsonBDemo_01 PARTITION OF jsonBDemo\n FOR VALUES FROM ('1') TO ('10');\n \nCREATE TABLE jsonBDemo_02 PARTITION OF jsonBDemo\n FOR VALUES FROM ('11') TO ('20');\n \nCREATE TABLE jsonBDemo_03 PARTITION OF jsonBDemo\n FOR VALUES FROM ('21') TO ('30');\n \nCREATE TABLE jsonBDemo_04 PARTITION OF jsonBDemo\n FOR VALUES FROM ('31') TO ('40');\n \n--Create indexes on partitions.\nCREATE INDEX ON jsonBDemo_01 USING BTREE ((data-&gt;'id'));\nCREATE INDEX ON jsonBDemo_02 USING BTREE ((data-&gt;'id'));\nCREATE INDEX ON jsonBDemo_03 USING BTREE ((data-&gt;'id'));\nCREATE INDEX ON jsonBDemo_04 USING BTREE ((data-&gt;'id'));\n \n--Insert Demo Data.\nINSERT INTO jsonBDemo (data) VALUES ('{\"id\":11,\"title\": \"Sleeping Beauties\", \"genres\": [\"Fiction\", \"Thriller\", \"Horror\"], \"published\": false}');  \nINSERT INTO jsonBDemo VALUES ('{\"id\":34,\"title\": \"Influence\", \"genres\": [\"Marketing &amp;amp; Sales\", \"Self-Help \", \"Psychology\"], \"published\": true}');  \nINSERT INTO jsonBDemo VALUES ('{\"id\":41,\"title\": \"The Dictator''s Handbook\", \"genres\": [\"Law\", \"Politics\"], \"authors\": [\"Bruce Bueno de Mesquita\", \"Alastair Smith\"], \"published\": true}');  \nINSERT INTO jsonBDemo VALUES ('{\"id\":16,\"title\": \"Deep Work\", \"genres\": [\"Productivity\", \"Reference\"], \"published\": true}');  \nINSERT INTO jsonBDemo VALUES ('{\"id\":22,\"title\": \"Siddhartha\", \"genres\": [\"Fiction\", \"Spirituality\"], \"published\": true}');<\/pre>\n<p>Then we select demo data we inserted.<\/p>\n<pre class=\"lang:default decode:true\">demo=# select * from jsonbdemo;<\/pre>\n<pre class=\"lang:default decode:true \">demo=# explain analyze select * from jsonbdemo where data-&gt;'id'='22';<\/pre>\n<p>Analyze result;<\/p>\n<pre class=\"lang:default decode:true \">Append  (cost=3.21..12.05 rows=7 width=32) (actual time=0.013..0.013 rows=1 loops=1)\n   -&gt;  Bitmap Heap Scan on jsonbdemo_03  (cost=3.21..12.02 rows=7 width=32) (actual time=0.012..0.012 rows=1\n loops=1)\n         Recheck Cond: ((data -&gt; 'id'::text) = '22'::jsonb)\n         Heap Blocks: exact=1\n         -&gt;  Bitmap Index Scan on jsonbdemo_03_expr_idx  (cost=0.00..3.21 rows=7 width=0) (actual time=0.008\n..0.008 rows=1 loops=1)\n               Index Cond: ((data -&gt; 'id'::text) = '22'::jsonb)\n Planning Time: 0.348 ms\n Execution Time: 0.145 ms\n(8 rows)<\/pre>\n<p>As seen above, the query uses the index on the 3rd partition.<\/p>\n<p>In this way, we created a partition on the column with jsonb data type.<\/p>\n<p>If you want to learn more about PostgreSQL partitioning, you should read my other article about partitioning &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/30\/table-partitioning-in-postgresql-11-2\/\" target=\"_blank\" rel=\"noopener noreferrer\">Table Partitioning in PostgreSQL 11.2<\/a>&#8221;<\/p>\n<p>Good luck with.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14731\" class=\"pvc_stats all  \" data-element-id=\"14731\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I will share an example that creates partition on JSONB column in PostgreSQL in this article. But first we need to know What JSON and JSONB are. What is JSON and JSONB? JSON and JSONB data types are available in PostgreSQL to store JSON data. Json stores data as a string and parses each query. &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_14731\" class=\"pvc_stats all  \" data-element-id=\"14731\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":483,"featured_media":14733,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[294,7737,7741,7738,7735,7736,7740,7739,7733,7732,7734],"class_list":["post-14731","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres","tag-auto-create-incremental-statistics","tag-create-partition-on-jsonb","tag-creating-partition-on-jsonb-column","tag-difference-between-json-and-jsonb","tag-how-do-we-create-partition-on-jsonb","tag-how-to-create-partition-on-jsonb-column-in-postgresql","tag-json-data-partitioning","tag-partitioning-json-data","tag-what-is-json","tag-what-is-json-and-jsonb","tag-what-is-jsonb"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Create Partition on JSONB column in PostgreSQL - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Create Partition on JSONB column in PostgreSQL\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Create Partition on JSONB column in PostgreSQL - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Create Partition on JSONB column in PostgreSQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-13T07:08:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-13T07:09:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png\" \/>\n\t<meta property=\"og:image:width\" content=\"456\" \/>\n\t<meta property=\"og:image:height\" content=\"267\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Yusuf KAHVEC\u0130\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Yusuf KAHVEC\u0130\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/\"},\"author\":{\"name\":\"Yusuf KAHVEC\u0130\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/695ad69b2bd896864842ba8772930150\"},\"headline\":\"How To Create Partition on JSONB column in PostgreSQL\",\"datePublished\":\"2020-01-13T07:08:59+00:00\",\"dateModified\":\"2020-01-13T07:09:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/\"},\"wordCount\":215,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png\",\"keywords\":[\"Auto Create Incremental Statistics\",\"Create Partition on JSONB\",\"Creating partition on jsonb column\",\"difference between JSON and JSONB\",\"how do we create partition on JSONB\",\"How To Create Partition on JSONB column in PostgreSQL\",\"JSON Data Partitioning\",\"Partitioning JSON Data\",\"What is JSON\",\"What is JSON and JSONB?\",\"What is JSONB\"],\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/\",\"name\":\"How To Create Partition on JSONB column in PostgreSQL - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png\",\"datePublished\":\"2020-01-13T07:08:59+00:00\",\"dateModified\":\"2020-01-13T07:09:00+00:00\",\"description\":\"How To Create Partition on JSONB column in PostgreSQL\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png\",\"width\":456,\"height\":267},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Create Partition on JSONB column in PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/695ad69b2bd896864842ba8772930150\",\"name\":\"Yusuf KAHVEC\u0130\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b4650ddb695869b13831d79f25c19ee915dc2151a7c8fcdf01538c295eb032?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b4650ddb695869b13831d79f25c19ee915dc2151a7c8fcdf01538c295eb032?s=96&d=mm&r=g\",\"caption\":\"Yusuf KAHVEC\u0130\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/yusufkahveci\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Create Partition on JSONB column in PostgreSQL - Database Tutorials","description":"How To Create Partition on JSONB column in PostgreSQL","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/","og_locale":"en_US","og_type":"article","og_title":"How To Create Partition on JSONB column in PostgreSQL - Database Tutorials","og_description":"How To Create Partition on JSONB column in PostgreSQL","og_url":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/","og_site_name":"Database Tutorials","article_published_time":"2020-01-13T07:08:59+00:00","article_modified_time":"2020-01-13T07:09:00+00:00","og_image":[{"width":456,"height":267,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png","type":"image\/png"}],"author":"Yusuf KAHVEC\u0130","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Yusuf KAHVEC\u0130","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/"},"author":{"name":"Yusuf KAHVEC\u0130","@id":"https:\/\/dbtut.com\/#\/schema\/person\/695ad69b2bd896864842ba8772930150"},"headline":"How To Create Partition on JSONB column in PostgreSQL","datePublished":"2020-01-13T07:08:59+00:00","dateModified":"2020-01-13T07:09:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/"},"wordCount":215,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png","keywords":["Auto Create Incremental Statistics","Create Partition on JSONB","Creating partition on jsonb column","difference between JSON and JSONB","how do we create partition on JSONB","How To Create Partition on JSONB column in PostgreSQL","JSON Data Partitioning","Partitioning JSON Data","What is JSON","What is JSON and JSONB?","What is JSONB"],"articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/","url":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/","name":"How To Create Partition on JSONB column in PostgreSQL - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png","datePublished":"2020-01-13T07:08:59+00:00","dateModified":"2020-01-13T07:09:00+00:00","description":"How To Create Partition on JSONB column in PostgreSQL","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/01\/Ads\u0131z-10.png","width":456,"height":267},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/01\/13\/how-to-create-partition-on-jsonb-column-in-postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Create Partition on JSONB column in PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/695ad69b2bd896864842ba8772930150","name":"Yusuf KAHVEC\u0130","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b4650ddb695869b13831d79f25c19ee915dc2151a7c8fcdf01538c295eb032?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b4650ddb695869b13831d79f25c19ee915dc2151a7c8fcdf01538c295eb032?s=96&d=mm&r=g","caption":"Yusuf KAHVEC\u0130"},"url":"https:\/\/dbtut.com\/index.php\/author\/yusufkahveci\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14731","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/483"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=14731"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/14731\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/14733"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=14731"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=14731"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=14731"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}