06 2021 档案

ERROR: pg_stat_statements must be loaded via shared_preload_libraries - 安装 - yum install -y postgresql-contrib.x86_64
摘要：1. 查看占io的sql: postgres=# select userid::regrole, dbid, query from pg_stat_statements order by total_time desc limit 5; ERROR: pg_stat_statements must 阅读全文
posted @ 2021-06-24 14:06 littlevigra 阅读(1862) 评论(0) 推荐(0) 编辑
pg_repack安装及使用
摘要：1. 安装依赖库：yum -y install postgresql-devel yum -y install postgresql-static 2. 下载源码包并解压进入wget http://api.pgxn.org/dist/pg_repack/1.4.5/pg_repack-1.4.5.z 阅读全文
posted @ 2021-06-21 22:30 littlevigra 阅读(568) 评论(0) 推荐(0) 编辑

点击右上角即可分享
微信分享提示