(0)準備
sudo su -
yum install gcc readline-devel openssl-devel postgresql-static
echo postgres | passwd --stdin postgres
(1)pg_hint_plan
su - postgres
tar xvzf pg_hint_plan96-1.2.4.tar.gz
cd pg_hint_plan96-1.2.4
make
exit
exit
sudo sh -c "cd /var/lib/pgsql/pg_hint_plan96-1.2.4;make install"
sudo su -
su - postgres
psql
\dx
create extension pg_hint_plan;
(2)pg_dbms_stats
su - postgres
tar xvzf pg_dbms_stats-1.3.11.tar.gz
cd pg_dbms_stats-1.3.11
make
exit
exit
sudo sh -c "cd /var/lib/pgsql/pg_dbms_stats-1.3.11;make install"
sudo su -
su - postgres
psql
\dx
create extension pg_dbms_stats;
(3)pg_repack
su - postgres
tar xvzf pg_repack-ver_1.4.4.tar.gz
cd pg_repack-ver_1.4.4
make
exit
exit
sudo sh -c "cd /var/lib/pgsql/pg_repack-ver_1.4.4;make install"
sudo su -
su - postgres
psql
\dx
create extension pg_repack;
(4)pg_statsinfo
su - postgres
tar xvzf pg_statsinfo-3.3.0.tar.gz
cd pg_statsinfo-3.3.0
make
exit
exit
sudo sh -c "cd /var/lib/pgsql/pg_statsinfo-3.3.0;make install"
sudo su -
su - postgres
vim postgresql.conf
shared_preload_libraries = 'pg_statsinfo' # 事前ロードを行う
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # ログファイル名を指定する
vim pg_hba.conf
local all postgres trust
psql -d postgres -c "SELECT statsinfo.snapshot('comment')"
pg_statsinfo -l