>Just out of curiosity, why is SPLIT / MERGE support not included for
>HASH partitions? Because sibling partitions can have a different
>modulus, you should be able to e.g. split a partition with (modulus,
>remainder) of (3, 1) into two partitions with (mod, rem) of (6, 1) and
>(6, 4) respectively, with the reverse being true for merge operations,
>right?
You are right, SPLIT/MERGE operations can be added for HASH-partitioning
in the future. But HASH-partitioning is rarer than RANGE- and
LIST-partitioning and I decided to skip it in the first step.
Maybe community will say that SPLIT/MERGE commands are not needed... (At
first step I would like to make sure that it is no true)
P.S. I attached patch with 1-line warning fix (for cfbot).
--
With best regards,
Dmitry Koval
Postgres Professional: http://postgrespro.com