Thread: What is R_PLANS?

What is R_PLANS?

From
Roberto Moreda
Date:
Please, can someone tell me what is the variable R_PLANS?

TIA

    Roberto

--
Roberto Moreda
Resp. Dpto. Informática Handem/San Luis
Tlf +34 981 779000
Fax +34 981 779022
Pol. Piadela Sur, Autovía A6 Sal.567
15300 Betanzos (A Coruña) - España

Re: [GENERAL] What is R_PLANS?

From
Bruce Momjian
Date:
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> Please, can someone tell me what is the variable R_PLANS?

In 6.5.*, rplans are on by default.  They allow multi-table joins to be
on the inside of a join, rather than only outer, which is a left-handed
join.  See src/backend/optimizer/README.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026