pgfincore安装

pgfincore

https://git.postgresql.org/gitweb


su - root
cd /opt/soft_bak
rz pgfincore-b2b53de
tar -zxvf pgfincore-b2b53de.tar.gz
cd pgfincore-b2b53de
which pg_config
export PATH=/opt/pgsql932/bin:$PATH
gmake clean
gmake
gmake install


create extension pgfincore


\df pgfad*


create table user_info(id int primary key, info text, crt_time timestamp);
insert into user_info select generate_series(1,500000), md5(random()::text), clock_timestamp();


select pg_total_relation_size('user_info');


select pg_total_relation_size('user_info')/1024/1024 MB


su - root


echo 3 > /proc/sys/vm/drop_caches  清理系统缓存


su - pg93




pgbench测试脚本
vi test.sql
\setrandom id 1 1000000
select * from user_info where id=:id;


pgbench -M prepared -n -r -f test.sql -c 16 -j 4 -T 10 postgres


select pgfadvise_willneed('user_info'::regclass);
select pgfadvise_willneed('user_info_pkey'::regclass);