【openGauss】openGauss创建分区表tzq_log_t

---

一、创建分区表tzq_log_t

CREATE TABLE tzq_log_t (
	id int8,
	name varchar(100)
)   PARTITION BY RANGE (id) (
	PARTITION P1 VALUES LESS THAN(1000),
	PARTITION P2 VALUES LESS THAN(2000),
	PARTITION P3 VALUES LESS THAN(3000),
	PARTITION P4 VALUES LESS THAN(4000),
	PARTITION P5 VALUES LESS THAN(5000),
	PARTITION P6 VALUES LESS THAN(6000),
	PARTITION P7 VALUES LESS THAN(7000),
	PARTITION P8 VALUES LESS THAN(MAXVALUE)
);

二、插入数据

insert into tzq_log_t select generate_series(1,8000),substr(md5(random()::text),2,5);

三、查询分区P1的行数。

SELECT count(*) FROM tzq_log_t PARTITION (P1);

四、查询某个值所在的分区的记录数

SELECT COUNT(*) FROM tzq_log_t PARTITION FOR (999);