pg_hint_plan icon indicating copy to clipboard operation
pg_hint_plan copied to clipboard

Extension adding support for optimizer hints in PostgreSQL

Results 54 pg_hint_plan issues
Sort by recently updated
recently updated
newest added

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