DROP INDEX idx_local_list_btree ;
DROP TABLE t_rebuild_p_list cascade;
CREATE TABLE t_rebuild_p_list (
id int,
name varchar(20)
)partition by list(id)
(partition p1 values (1,3,5),
partition p2 values (2,4,6),
partition p3 values (7,8,9,10));
INSERT INTO t_rebuild_p_list values(1,'liuyi');
INSERT INTO t_rebuild_p_list values(2,'chener');
INSERT INTO t_rebuild_p_list values(3,'zhangsan');
INSERT INTO t_rebuild_p_list values(4,'lisi');
INSERT INTO t_rebuild_p_list values(5,'wangwu');
INSERT INTO t_rebuild_p_list values(6,'zhaoliu');
INSERT INTO t_rebuild_p_list values(7,'sunqi');
INSERT INTO t_rebuild_p_list values(8,'zhouba');
INSERT INTO t_rebuild_p_list values(9,'wujiu');
CREATE INDEX idx_local_list_btree ON t_rebuild_p_list using btree(id) local;

--打开两个会话
--会话1不断执行DML和DQL操作：
do language plpgsql $$    
declare    
begin    
  for i in 5..100000 loop    
    INSERT INTO t_rebuild_p_list values(10,'zhengshi');
     DELETE FROM t_rebuild_p_list WHERE id=10;
     PERFORM name FROM t_rebuild_p_list WHERE id<6 order by name;
    commit;    
  end loop;    
end;    
$$;    
--会话2重建索引
REINDEX INDEX concurrently  idx_local_list_btree ;
REINDEX INDEX concurrently  idx_local_list_btree partition p1_id_idx ;
REINDEX INDEX concurrently idx_local_list_btree partition p2_id_idx ;
REINDEX INDEX concurrently  idx_local_list_btree partition p3_id_idx ;