postgres安装pg_buffercache扩展

1.查看是否安装了pg_buffercache

?

1 2 3 4 5 6

postgres=#  \dx                       List of installed extensions       Name      | Version |   Schema   |           Description           ----------------+---------+------------+---------------------------------  plpgsql        | 1.0     | pg_catalog | PL/pgSQL procedural language (1 rows)

2.查看当前服务器是否可以使用pg_buffercache扩展

?

1	postgres=# select * from pg_available_extensions where name='pg_buffercache';

3.安装pg_buffercache扩展

?

1 2 3 4 5 6 7 8

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

?

1	postgres-# drop extension pg_buffercache;