Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: Rob Sargent <robjsargent@gmail.com>
Mime-Version: 1.0 (1.0)
Subject: Re: pg_hint_tables
Date: Tue, 30 Sep 2025 14:24:48 -0600
Message-Id: <10E7B5A6-9AAF-4B55-A604-2E005530B391@gmail.com>
References: <cfeea76b-b873-4885-b9a8-ae6b5414267d@aklaver.com>
Cc: Kam Fook Wong <kamfook.wong@thomsonreuters.com>,
 pgsql-general@postgresql.org
In-Reply-To: <cfeea76b-b873-4885-b9a8-ae6b5414267d@aklaver.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Archived-At: <https://www.postgresql.org/message-id/10E7B5A6-9AAF-4B55-A604-2E005530B391%40gmail.com>
Precedence: bulk

I am top posting because I believe you have =E2=80=9Chikacked=E2=80=9D a thr=
ead.=20

Rather than replying to an existing thread unrelated to your topic you shoul=
d start your own specific thread.=20


> On Sep 30, 2025, at 2:13=E2=80=AFPM, Adrian Klaver <adrian.klaver@aklaver.=
com> wrote:
>=20
> =EF=BB=BFOn 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 P=
ostgres parameter "pg_hint_plan.enable_hint_table =3D 1".  Then I logout but=
 can't login anymore with the following error message.
>=20
> To be clear it is pg_hint_plan not pg_hint_tables?
>=20
>> =E2=80=9Cpostgres@postgres:[2719]:ERROR:  relation "hint_plan.hints" does=
 not exist at character 21=E2=80=9D.
>> I undo the changes, log back in.  Can't find a good resources that lead m=
e to the root cause.  So I try a few other things, see below.  But no luck. =
 Any guidance or help is greatly appreciated.
>=20
> =46rom here:
>=20
> https://github.com/ossc-db/pg_hint_plan/blob/master/docs/installation.md
>=20
> Did you do?:
>=20
> "
> Loading pg_hint_plan
>=20
> pg_hint_plan does not require CREATE EXTENSION. Loading it with a LOAD com=
mand will activate it and of course you can load it globally by setting shar=
ed_preload_libraries in postgresql.conf. Or you might be interested in ALTER=
 USER SET/ALTER DATABASE SET for automatic loading in specific sessions.
>=20
> postgres=3D# 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
>=20
>=20