postgresql 表分区的测试用例

----大数据数据表分区做法
CREATE TABLE bcompany_01(CHECK(cpy_id<=500000) ) INHERITS (bcompany);

CREATE TABLE bcompany_02(CHECK(cpy_id<=1000000 and cpy_id>500000) ) INHERITS (bcompany);

CREATE TABLE bcompany_03(CHECK(cpy_id<=1500000 and cpy_id>1000000) ) INHERITS (bcompany);

CREATE TABLE bcompany_04(CHECK(cpy_id<=2000000 and cpy_id>1500000) ) INHERITS (bcompany);

CREATE OR REPLACE RULE bcompany_01_partition AS
 ON INSERT TO bcompany WHERE (cpy_id<=500000)
 DO INSTEAD
  INSERT INTO bcompany_01 VALUES(NEW.CPY_ID,NEW.CPY_CODE,NEW.CPY_NAME,NEW.CPY_INDUSTRY,NEW.CPY_KIND,
  NEW.CPY_MEMO,NEW.CPY_ADDRESS,NEW.CPY_ZIP,NEW.CPY_LINK,NEW.CPY_WEB,NEW.CPY_FAX,NEW.CPY_PHONE,NEW.CPY_EMAIL);

CREATE OR REPLACE RULE bcompany_02_partition AS
 ON INSERT TO bcompany WHERE (cpy_id<=1000000 and cpy_id>500000)
 DO INSTEAD
  INSERT INTO bcompany_02 VALUES(NEW.CPY_ID,NEW.CPY_CODE,NEW.