文件名称：greenplum数据库扩展分区函数.rar
文件大小：125KB
文件格式：RAR
更新时间：2024-09-15 04:49:46
greenplum扩展分区函数 greenplum函数 gp扩展分区函数
– 调用：扩展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
【文件预览】：
greenplum数据库增加分区函数.pdf