|Subject||Re: [firebird-support] Re: Firebird performance vs PostgreSQL|
On 29 Sep 2017, at 08:34, Dmitry Yemanov dimitr@... [firebird-support] <email@example.com> wrote:
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.