1.查看是否安装了pg_buffercache
postgres=# \dx
List of installed extensions
Name | Version | Schema | Description
----------------+---------+------------+---------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(1 rows)
2.查看当前服务器是否可以使用pg_buffercache扩展
postgres=# select * from pg_available_extensions where name='pg_buffercache';
3.安装pg_buffercache扩展
postgres-# create extension pg_buffercache;
postgres-# \dx
List of installed extensions
Name | Version | Schema | Description
----------------+---------+------------+---------------------------------
pg_buffercache | 1.3 | public | examine the shared buffer cache
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
(2 rows)
4.删除pg_buffercache
postgres-# drop extension pg_buffercache;