29.09.2017 01:08, Ertan Küçükoğlu wrote: Answers can be found in the plans:
> PLAN JOIN (RAPOR_EK ORDER rapor_ek_pkey, SORT (DT M NATURAL)) This join plan is terrible for FB. Are KAYNAGAGORE and SEBEBEGORE indexed? They seem not. > Merge Left Join (cost=6600.19..6610.98 rows=560 width=340) FB cannot perform merge- or hash-join for outer joins (yet). When important indices are missing, this becomes a problem. Dmitry