Re: enforcing a plan (in brief) - Mailing list pgsql-hackers

Hicham G. Elmongui wrote:
> Is there a way to bypass the optimizer and to specify a plan to be executed?
> 
> Something like:
> 
> 
> 
> Limit 
>   -> Nested Loop 
>      -> Nested Loop  
>         -> Seq Scan on tab00 t00 
>         -> Index Scan using tab03_pkey on tab03 t03  
>                 Index Cond: ("outer".id = t03.id)
>      -> Index Scan using tab01_pkey on tab01 t01  
>               Index Cond: ("outer".id = t01.id)

No, we feel that is of limited value.  If the optimizer isn't doing
things properly, we will fix it.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073