Slide 25
Slide 25 text
Novedades de PostgreSQL 11
Particionado por Hash - Ejemplo
►
CREATE TABLE hp (id serial, foo text )
PARTITION BY HASH (foo);
►
CREATE TABLE hp_0 PARTITION OF hp FOR VALUES WITH
(MODULUS 3, REMAINDER 0);
►
CREATE TABLE hp_1 PARTITION OF hp FOR VALUES WITH
(MODULUS 3, REMAINDER 1);
►
CREATE TABLE hp_2 PARTITION OF hp FOR VALUES WITH
(MODULUS 3, REMAINDER 2);