#postgresql分区表重要参数配置
constraint_exclusion = partition
enable_partitionwise_aggregate = on #(分区级别的聚合:PostgreSQL 11附带了一个名为enable_partitionwise_aggregate的新选项,可以打开该选项以使查询计划程序将聚合推送到分区级别。 默认情况下,此选项已关闭)
#创建分区表
CREATE TABLE repayments(
“id” int8 NOT NULL DEFAULT nextval(‘repayments_id_seq’::regclass),
“merchant_id” int4,
“batch_no” varchar COLLATE “pg_catalog”.“default” NOT NULL,
“batch_type” varchar COLLATE “pg_catalog”.“default” DEFAULT ‘’::character varying,
“batch_date” varchar COLLATE “pg_catalog”.“default” DEFAULT ‘’::character varying,
“out_card_no” varchar COLLATE “pg_catalog”.“default” DEFAULT ‘’::character varying,
“amount” numeric DEFAULT 0,
“interest_amount” numeric DEFAULT 0,
“in_card_no” varchar COLLATE “pg_catalog”.“default” DEFAULT ‘’::character varying,
“currency” varchar COLLATE “pg_catalog”.“default” DEFAULT ‘’::character varying,
“out_fee_mode”