postgresql10 range分区法

最新推荐文章于 2024-09-11 14:34:14 发布

菜java一个

最新推荐文章于 2024-09-11 14:34:14 发布

阅读量864

点赞数

CREATE TABLE range_parted (
join_date date
) PARTITION BY RANGE (join_date);
CREATE TABLE range_parted1 PARTITION OF range_parted FOR VALUES from ( '2018-01-01') TO ( '2018-02-01');
CREATE TABLE range_parted2 PARTITION OF range_parted FOR VALUES FROM ( '2018-02-01') TO ( '2018-03-01');
CREATE TABLE range_parted3 PARTITION OF range_parted FOR VALUES FROM ( '2018-03-01') TO ( '2018-04-01');

insert into range_parted1 values('2018-02-01');

explain select *from range_parted where join_date='2018-02-01';

自己调试后发现重点写法 from ( '2018-01-01') TO ( '2018-02-01');

from里的值表示包含这个值，to里的值不包含。