greenplum数据库扩展分区函数.rar

– 调用：扩展5个月分区 dw_dat=> select add_partition_month(5); – 查看表： dw_dat=> \d+ gw_test_info; Append-Only Columnar Table “public.gw_test_info” Column | Type | Modifiers | Storage | Stats target | Compression Type | Compression Level | Block Size | Description -------------±----------------------------±----------±--------±-------------±-----------------±------------------±----------- ±------------ id | numeric | not null | main | | zlib | 5 | 32768 | create_time | timestamp without time zone | not null | plain | | zlib | 5 | 32768 | Checksum: t Child tables: gw_test_info_p201803, gw_test_info_p201804, gw_test_info_p201805, gw_test_info_p201806, gw_test_info_p201807, gw_test_info_p201808, gw_test_info_p201809 Distributed by: (id) Partition by: (create_time) Options: appendonly=true, orientation=column, compresstype=zlib, compresslevel=5