qq_29579431的博客

官网下载https://www.postgresql.org/ftp/source/v9.5.25/选择postgresql-9.5.25.tar.gz解压tar -zxvf postgresql-9.5.25.tar.gz安装postgresql进入文件夹，执行./configure --without-readlinemakesudo make install安装工具（建议安装）cd contribmake && sudo make install验证

hypopg是一个构建虚拟索引的postgresql插件，本安装版本为postgresql12.6，系统为Ubuntu 16.04。首先安装postgresql-server-dev-12sudo apt-get install postgresql-server-dev-12下载hypopg并解压https://github.com/HypoPG/hypopg我下载的是hypopg-REL1_STABLE.zip，解压后为进入文件夹，执行如下命令：makesudo make inst

查看虚拟索引SELECT * FROM hypopg_list_indexes();构建虚拟索引SELECT * FROM hypopg_create_index('CREATE INDEX ON hypo (id)');

查看数据库\l连接数据库\c database_name查询主键SELECT pg_constraint.conname AS pk_name, pg_attribute.attname AS colname, pg_type.typname AS typenameFROM pg_constraintINNER JOIN pg_class ON pg_constraint.conrelid = pg_class.oidINNER JOIN pg_attri

postgresql版本：9.5.23操作系统：Ubuntu 16.04查看配置文件位置在psql中输入如下sql：select name,setting from pg_settings where category='File Locations';其中config_file对应的就是配置文件位置修改配置文件注意：修改前将源文件备份打开对应文件，将如下变量对应的注释去掉，并且修改其中的值：log_statement = 'all'# This is used when loggi