postgres安装pg_buffercache扩展

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;

　　

转载于:https://www.cnblogs.com/abclife/p/10938005.html