hypopg1.3.0 使用-常用命令

查看并添加postgresql插件

查看

\dx

添加

CREATE EXTENSION hypopg;

查看虚拟索引

命令失效

SELECT * FROM hypopg_list_indexes();

改为

select * from hypopg_list_indexes;

构建虚拟索引

SELECT * FROM hypopg_create_index('CREATE INDEX ON hypo (id)');

预估虚拟索引大小

失效

SELECT indexname, pg_size_pretty(hypopg_relation_size(indexrelid))
  FROM hypopg_list_indexes() ;

改为

SELECT pg_size_pretty(hypopg_relation_size(oid)) ;

删除虚拟索引

命令失效

select hypopg_drop_index(oid) FROM hypopg_list_indexes();

改用

select hypopg_drop_index(oid);