4.6.4 pg_dbms

Set the postgresql.conf file parameter.
Add "pg_dbms_stats" to the "shared_preload_libraries" parameter.

As superuser, run the following command:

$ su -
Password:******
# cp -r /opt/fsepv<x>server64/OSS/pg_dbms_stats/* /opt/fsepv<x>server64

Restart Fujitsu Enterprise Postgres.
Run CREATE EXTENSION for the database that will use this feature.
The target database is described as "postgres" here.
Use the psql command to connect to the "postgres" database.
```
postgres=# CREATE EXTENSION pg_dbms_stats;
CREATE EXTENSION
```
See
Refer to "Enhanced Query Plan Stability" in the Operation Guide for details.

Note

Unsetting pg_dbms_stats causes statistics managed by pg_dbms_stats to be lost. Therefore, it is recommended that you back up each table in the dbms_stats folder of each database in binary format if you may want to use pg_dbms_stats again later.

postgres › # COPY <dbms_stats Schema's table name> TO '<Filename>' FORMAT binary;

Execute DROP EXTENSION for the database that will use this feature.
Use the psql command to connect to the "postgres" database.
```
postgres=# DROP EXTENSION pg_dbms_stats CASCADE;
DROP EXTENSION
```

As superuser, run the following command:

$ su -
Password:******
# rm -rf /opt/fsepv<x>server64/filesCopiedDuringSetup

Information

The files copied during setup can be checked below.

# find /opt/fsepv<x>server64/OSS/pg_dbms_stats

Set the postgresql.conf file parameters.
Delete "pg_dbms_stats" to the shared_preload_libraries parameter.
Restart Fujitsu Enterprise Postgres.

4.6.4 pg_dbms_stats

4.6.4.1 Setting Up pg_dbms_stats

4.6.4.2 Removing pg_dbms_stats