Feedback-ID: i76984098:Fastmail
Message-ID: <cfeea76b-b873-4885-b9a8-ae6b5414267d@aklaver.com>
Date: Tue, 30 Sep 2025 13:13:21 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: pg_hint_tables
To: "Wong, Kam Fook (TR Technology)" <kamfook.wong@thomsonreuters.com>,
 "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
References: <CACmLaviY60Vx64hcacS687kBA3tXRfcYzrSJb6XaHU4X5qOrmQ@mail.gmail.com>
 <01e5ec17-de91-4197-81d2-fa505802ab57@aklaver.com>
 <DM4PR03MB603219DBB6FF9973DFCE02DEFE1AA@DM4PR03MB6032.namprd03.prod.outlook.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <DM4PR03MB603219DBB6FF9973DFCE02DEFE1AA@DM4PR03MB6032.namprd03.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/cfeea76b-b873-4885-b9a8-ae6b5414267d%40aklaver.com>
Precedence: bulk

On 9/30/25 12:51, Wong, Kam Fook (TR Technology) wrote:
> I am trying to use pg_hint_tables in AWS Aurora Postgres.  I changed the Postgres parameter "pg_hint_plan.enable_hint_table = 1".  Then I logout but can't login anymore with the following error message.

To be clear it is pg_hint_plan not pg_hint_tables?

> 
> “postgres@postgres:[2719]:ERROR:  relation "hint_plan.hints" does not exist at character 21”.
> 
> I undo the changes, log back in.  Can't find a good resources that lead me to the root cause.  So I try a few other things, see below.  But no luck.  Any guidance or help is greatly appreciated.

 From here:

https://github.com/ossc-db/pg_hint_plan/blob/master/docs/installation.md

Did you do?:

"
Loading pg_hint_plan

pg_hint_plan does not require CREATE EXTENSION. Loading it with a LOAD 
command will activate it and of course you can load it globally by 
setting shared_preload_libraries in postgresql.conf. Or you might be 
interested in ALTER USER SET/ALTER DATABASE SET for automatic loading in 
specific sessions.

postgres=# LOAD 'pg_hint_plan';
LOAD
"
> 
> ALTER EXTENSION pg_hint_plan  UPDATE TO '1.4';
> GRANT SELECT, INSERT, UPDATE, DELETE ON hint_plan.hints TO PUBLIC;
> GRANT USAGE ON SCHEMA hint_plan TO PUBLIC;
> 
> Thank you
> Kam Fook Wong
-- 
Adrian Klaver
adrian.klaver@aklaver.com