postgresql 分表

create table test_part
(
    id   int,
    name varchar,
    age  numeric
) partition by range (age);
create table test_part_yong partition of test_part for values from (MINVALUE ) to (25);
create table test_part_medium partition of test_part for values from (25) to (75);
create table test_part_old partition of test_part for values from (75) to (maxvalue );

配合触发器功能可以自动创建分表

懂得,原来世界如此简单!