1，  创建分区表 create table partitioned (        dt date,        a int );   2，  创建分区表 create table p20090101 ( check(dt >= DATE ‘ 2009-01-01’ AND dt < DATE ‘2009-01-02’) ) inherits(partitioned);   create table p20090102 ( check(dt >= DATE ‘2009-01-02’ AND dt < DATE ‘2009-01-03’) ) inherits(partitioned);     3，  创建规则 CREATE OR REPLACE RULE partitioned_p20090101 AS ON INSERT TO partitioned WHERE       (dt >= DATE ‘2009-01-01’ AND dt < DATE ‘2009-01-02’) DO INSTEAD          INSERT INTO p20090101 VALUES (NEW.dt, NEW.a );   CREATE OR REPLACE RULE partitioned_p20090102 AS ON INSERT TO partitioned WHERE       (dt >= DATE ‘2009-01-02’ AND logdate < DATE ‘2009-01-03’) DO INSTEAD          INSERT INTO p20090102 VALUES (NEW.dt, NEW.a )   4，  打开分区消除 SET constraint_exclusion = on;

评论