4.7.3 pg_hint

Set the postgresql.conf file parameters.
Add "pg_hint_plan" to the "shared_preload_libraries" parameter.

As superuser, run the following command:

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

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

Note

Unsetting pg_hint_plan will cause hints registered in the hint_plan.hints table to be lost. Therefore, it is recommended that pg_dump back up the hint_plan.hints table for each database if it is likely that pg_hint_plan will be used again later.

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_hint_plan 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_hint_plan

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

4.7.3 pg_hint_plan

4.7.3.1 Setting Up pg_hint_plan

4.7.3.2 Removing pg_hint_plan