摘要： db_test=# create index idx_name1 on tb_aa(name1);CREATE INDEX db_test=# SELECT pg_size_pretty(pg_total_relation_size('tb_aa')); pg_size_pretty 2469 MB 阅读全文

摘要： postgres=#create table tb_aa(n_id int not null primary key,name1 varchar(32),name2 varchar(32),name3 varchar(32),name4 varchar(32),name5 varchar(32),n 阅读全文

摘要： 环境: OS:Centos 7 DB:pg12 1.查看有那些可以使用的版本 [root@localhost bin]# yum list pg_repack* Loaded plugins: fastestmirror, langpacks Loading mirror speeds from c 阅读全文