public inbox for [email protected]
help / color / mirror / Atom feedRe: pg_hint_tables
2+ messages / 2 participants
[nested] [flat]
* Re: pg_hint_tables
@ 2025-09-30 20:13 Adrian Klaver <[email protected]>
2025-09-30 20:24 ` Re: pg_hint_tables Rob Sargent <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Adrian Klaver @ 2025-09-30 20:13 UTC (permalink / raw)
To: Wong, Kam Fook (TR Technology) <[email protected]>; pgsql-general
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
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_hint_tables
2025-09-30 20:13 Re: pg_hint_tables Adrian Klaver <[email protected]>
@ 2025-09-30 20:24 ` Rob Sargent <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Rob Sargent @ 2025-09-30 20:24 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: Kam Fook Wong <[email protected]>; pgsql-general
I am top posting because I believe you have “hikacked” a thread.
Rather than replying to an existing thread unrelated to your topic you should start your own specific thread.
> On Sep 30, 2025, at 2:13 PM, Adrian Klaver <[email protected]> wrote:
>
> 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
> [email protected]
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-09-30 20:24 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-09-30 20:13 Re: pg_hint_tables Adrian Klaver <[email protected]>
2025-09-30 20:24 ` Rob Sargent <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox