pg_hint_plan
pg_hint_plan copied to clipboard
Extension adding support for optimizer hints in PostgreSQL
Maskout script used for tests `maskout.sh` doesn't seems to work on MAC machines. Particularly, issue is with `sed` command and script fails to mask cost/width values in the query plan....
``` create extension hypopg ; load 'pg_hint_plan'; create table t1(a int, b int, c int); create index ON t1 (a); select hypopg_create_index('create index on t1(b)'); explain select/*+ indexscan(t1 t1_a_idx)*/ from...
Hints don't work on view level, for example: ``` CREATE OR REPLACE VIEW example_v AS SELECT /*+ NoIndexScan(le) */ le.id ,le.code2 FROM table1 le WHERE le.code2= 'X'; ``` The execution...
Hello pg_hint_plan devs. Question. I have a request, fairly simple. My question, is there way to ensure single thread processing of a request. Something, that other RDBMS support with similar...