Hash partition

Partition by a hash.

Hash partition splits by a hash value. Ideal for even distribution.

CREATE TABLE orders (...) PARTITION BY HASH (id);
CREATE TABLE orders_0 PARTITION OF orders
  FOR VALUES WITH (MODULUS 4, REMAINDER 0);

4 partitions, by id mod 4.

The table orders is created.

Hash partition — details

Hash partition defines partition count with MODULUS and REMAINDER.

For example, four partitions with MODULUS 4 and REMAINDER 0 to 3 spread rows roughly evenly by the hash of the id.

Create the orders_0 partition with FOR VALUES WITH (MODULUS 4, REMAINDER 0).

Show example solution

CREATE TABLE orders_0 PARTITION OF orders
  FOR VALUES WITH (MODULUS 4, REMAINDER 0);

Add HASH

PARTITION BY ____ (id)

Show answer

PARTITION BY HASH (id)