Re: [firebird-support] Full outer join poor performance.

On 05/18/2016 09:03 AM, liviuslivius liviusliv...@poczta.onet.pl [firebird-support] wrote: Hi, as mentioned by other - this is because of outer join look at: http://tracker.firebirdsql.org/browse/CORE-4823 regards, Karol Bieniaszewski W dniu 2016-05-17 12:20:42 użytkownik agharta

Re: [firebird-support] Full outer join poor performance.

On 05/17/2016 09:52 PM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 17.05.2016 12:20, agharta aghart...@gmail.com [firebird-support] wrote: >> Any ideas about why fb take too long time to execute the query (and >> scans so mutch rows)? > PG can do hash full outer join,

Re: [firebird-support] Full outer join poor performance.

On 05/17/2016 10:51 PM, setysvar setys...@gmail.com [firebird-support] wrote: Den 17.05.2016 12:20, skrev agharta aghart...@gmail.com [firebird-support]: > Hi all, this is my first post and my english is bad, please be patient :-) > > I've a problem with a full outer join, let me explain. >

Re: [firebird-support] Full outer join poor performance.

Hi,   as mentioned by other - this is because of outer join look at: http://tracker.firebirdsql.org/browse/CORE-4823   regards, Karol Bieniaszewski   W dniu 2016-05-17 12:20:42 użytkownik agharta aghart...@gmail.com [firebird-support] napisał:   Hi all, this is

Re: [firebird-support] Full outer join poor performance.

17.05.2016 12:20, agharta aghart...@gmail.com [firebird-support] wrote: > Any ideas about why fb take too long time to execute the query (and > scans so mutch rows)? PG can do hash full outer join, FB cannot. That's all. -- WBR, SD.

[firebird-support] Full outer join poor performance.

Hi all, this is my first post and my english is bad, please be patient :-) I've a problem with a full outer join, let me explain. 2 tables (10 rows each), 2 cte, 2 full outer joins, 100 rows output. No indexes. Execution took about 40s. in postgres (i've do a equal test