{"id":11044,"date":"2018-03-23T12:45:28","date_gmt":"2018-03-23T11:45:28","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/"},"modified":"2023-06-09T16:56:17","modified_gmt":"2023-06-09T14:56:17","slug":"hash-partitioning-in-postgresql-11","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/","title":{"rendered":"Hash Partitioning in PostgreSQL 11"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

PostgreSQL 10 comes with partition support. But Hash Partitioning was not supported. PostgreSQL 11 will support Hash Partition.
\nIn the documentation we can read
\nThe table is partitioned by specifying a modulus and a remainder for each partition. Each partition will hold the rows for which the hash value of the partition key divided by the specified modulus will produce the specified remainder.<\/em>
\nFor this demonstration let\u2019s create a table with a hash partition<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
drop<\/code> table<\/code> dept;<\/code><\/div>\n
create<\/code> table<\/code> dept (id\u00a0 <\/code>int<\/code> primary<\/code> key<\/code>) partition <\/code>by<\/code> hash(id) ; <\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s create for example 10 partitions<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n<\/td>\n
\n
\n
create<\/code> table<\/code> dept_1 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 0);<\/code><\/div>\n
create<\/code> table<\/code> dept_2 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 1);<\/code><\/div>\n
create<\/code> table<\/code> dept_3 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 2);<\/code><\/div>\n
create<\/code> table<\/code> dept_4 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 3);<\/code><\/div>\n
create<\/code> table<\/code> dept_5 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 4);<\/code><\/div>\n
create<\/code> table<\/code> dept_6 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 5);<\/code><\/div>\n
create<\/code> table<\/code> dept_7 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 6);<\/code><\/div>\n
create<\/code> table<\/code> dept_8 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 7);<\/code><\/div>\n
create<\/code> table<\/code> dept_9 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 8);<\/code><\/div>\n
create<\/code> table<\/code> dept_10 partition <\/code>of<\/code> dept <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (MODULUS 10, REMAINDER 9);<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can verify that partitions are created using the d+ command<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n<\/td>\n
\n
\n
(postgres@[<\/code>local<\/code>]:5432) [test] > d+ dept<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Table<\/code> \"public.dept\"<\/code><\/div>\n
\u00a0<\/code>Column<\/code> |\u00a0 Type\u00a0\u00a0 | Collation | Nullable | <\/code>Default<\/code> | Storage | Stats target | De<\/code><\/div>\n
scription<\/code><\/div>\n
--------+---------+-----------+----------+---------+---------+--------------+---<\/code><\/div>\n
----------<\/code><\/div>\n
\u00a0<\/code>id\u00a0\u00a0\u00a0\u00a0 | <\/code>integer<\/code> |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | <\/code>not<\/code> null<\/code> |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | plain\u00a0\u00a0 |\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
Partition <\/code>key<\/code>: HASH (id)<\/code><\/div>\n
Indexes:<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>\"dept_pkey\"<\/code> PRIMARY<\/code> KEY<\/code>, btree (id)<\/code><\/div>\n
Partitions: dept_1 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 0),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_10 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 9),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_2 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 1),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_3 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 2),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_4 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 3),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_5 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 4),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_6 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 5),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_7 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 6),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_8 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 7),<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>dept_9 <\/code>FOR<\/code> VALUES<\/code> WITH<\/code> (modulus 10, remainder 8)<\/code><\/div>\n
<\/div>\n
(postgres@[<\/code>local<\/code>]:5432) [test] ><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s insert some rows in the table dept<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
(postgres@[<\/code>local<\/code>]:5432) [test] > <\/code>insert<\/code> into<\/code> dept (<\/code>select<\/code> generate_series(0,200000));<\/code><\/div>\n
INSERT<\/code> 0 200001<\/code><\/div>\n
(postgres@[<\/code>local<\/code>]:5432) [test] ><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can verify that rows are not in the base table<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
(postgres@[<\/code>local<\/code>]:5432) [test] > <\/code>select<\/code> count<\/code>(*) <\/code>from<\/code>\u00a0 only<\/code> dept ;<\/code><\/div>\n
\u00a0<\/code>count<\/code><\/div>\n
-------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>0<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
(postgres@[<\/code>local<\/code>]:5432) [test] ><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

But that row are in the partitions<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
(postgres@[<\/code>local<\/code>]:5432) [test] > <\/code>select<\/code> count<\/code>(*) <\/code>from<\/code>\u00a0 dept ;<\/code><\/div>\n
\u00a0<\/code>count<\/code><\/div>\n
--------<\/code><\/div>\n
\u00a0<\/code>200001<\/code><\/div>\n
(1 row)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

What we can also observe it that rows are uniformly distributed among partitions. This distribution is automatically done by the hash algorithm.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n<\/td>\n
\n
\n
(postgres@[<\/code>local<\/code>]:5432) [test] > <\/code>select<\/code> count<\/code>(*) <\/code>from<\/code>\u00a0 only<\/code> dept_1 ;<\/code><\/div>\n
\u00a0<\/code>count<\/code><\/div>\n
-------<\/code><\/div>\n
\u00a0<\/code>19982<\/code><\/div>\n
(1 row)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><\/div>\n
(postgres@[<\/code>local<\/code>]:5432) [test] > <\/code>select<\/code> count<\/code>(*) <\/code>from<\/code>\u00a0 only<\/code> dept_2 ;<\/code><\/div>\n
\u00a0<\/code>count<\/code><\/div>\n
-------<\/code><\/div>\n
\u00a0<\/code>20199<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
(postgres@[<\/code>local<\/code>]:5432) [test] > <\/code>select<\/code> count<\/code>(*) <\/code>from<\/code>\u00a0 only<\/code> dept_3 ;<\/code><\/div>\n
\u00a0<\/code>count<\/code><\/div>\n
-------<\/code><\/div>\n
\u00a0<\/code>19770<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
(postgres@[<\/code>local<\/code>]:5432) [test] > <\/code>select<\/code> count<\/code>(*) <\/code>from<\/code>\u00a0 only<\/code> dept_5 ;<\/code><\/div>\n
\u00a0<\/code>count<\/code><\/div>\n
-------<\/code><\/div>\n
\u00a0<\/code>20068<\/code><\/div>\n
(1 row)<\/code><\/div>\n
<\/div>\n
(postgres@[<\/code>local<\/code>]:5432) [test] ><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw PostgreSQL 10 comes with partition support. But Hash Partitioning was not supported. PostgreSQL 11 will support Hash Partition. In the documentation we can read The table is partitioned by specifying a modulus and a remainder for each partition. Each partition will hold the rows for which the hash value of the partition […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1322,77,1323],"type_dbi":[],"class_list":["post-11044","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-hash-partitioning","tag-postgresql","tag-postgresql-11"],"acf":[],"yoast_head":"\nHash Partitioning in PostgreSQL 11 - dbi Blog<\/title>\n<meta name=\"description\" content=\"PostgreSQL 11, Hash Partition, Modulus, Remainder\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hash Partitioning in PostgreSQL 11\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL 11, Hash Partition, Modulus, Remainder\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-23T11:45:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-09T14:56:17+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Hash Partitioning in PostgreSQL 11\",\"datePublished\":\"2018-03-23T11:45:28+00:00\",\"dateModified\":\"2023-06-09T14:56:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/\"},\"wordCount\":148,\"commentCount\":0,\"keywords\":[\"Hash Partitioning\",\"PostgreSQL\",\"PostgreSQL 11\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/\",\"name\":\"Hash Partitioning in PostgreSQL 11 - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2018-03-23T11:45:28+00:00\",\"dateModified\":\"2023-06-09T14:56:17+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"PostgreSQL 11, Hash Partition, Modulus, Remainder\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hash Partitioning in PostgreSQL 11\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Hash Partitioning in PostgreSQL 11 - dbi Blog","description":"PostgreSQL 11, Hash Partition, Modulus, Remainder","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:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/","og_locale":"en_US","og_type":"article","og_title":"Hash Partitioning in PostgreSQL 11","og_description":"PostgreSQL 11, Hash Partition, Modulus, Remainder","og_url":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/","og_site_name":"dbi Blog","article_published_time":"2018-03-23T11:45:28+00:00","article_modified_time":"2023-06-09T14:56:17+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Hash Partitioning in PostgreSQL 11","datePublished":"2018-03-23T11:45:28+00:00","dateModified":"2023-06-09T14:56:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/"},"wordCount":148,"commentCount":0,"keywords":["Hash Partitioning","PostgreSQL","PostgreSQL 11"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/","url":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/","name":"Hash Partitioning in PostgreSQL 11 - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2018-03-23T11:45:28+00:00","dateModified":"2023-06-09T14:56:17+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"PostgreSQL 11, Hash Partition, Modulus, Remainder","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/hash-partitioning-in-postgresql-11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Hash Partitioning in PostgreSQL 11"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11044","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=11044"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11044\/revisions"}],"predecessor-version":[{"id":25767,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/11044\/revisions\/25767"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=11044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=11044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=11044"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=11044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}