Re: comparison between 2 execution plans

On 05/05/2018 10:51 AM, Neto pr wrote: Dear, 2018-05-05 9:57 GMT-07:00 Adrian Klaver >: On 05/05/2018 06:26 AM, Neto pr wrote: It might help if you explained what 'version with source code changed by me' means? Postgresql with modified sourc

Re: comparison between 2 execution plans

Dear, 2018-05-05 9:57 GMT-07:00 Adrian Klaver : > On 05/05/2018 06:26 AM, Neto pr wrote: > >> Dear all >> >> Could you help me understand these two execution plans for the same query >> (query 3 benchmark TPCH www.tpc.org/tpch ), >> executed in two different environments

Re: comparison between 2 execution plans

On 05/05/2018 06:26 AM, Neto pr wrote: Dear all Could you help me understand these two execution plans for the same query (query 3 benchmark TPCH www.tpc.org/tpch ), executed in two different environments of Postgresql, as described below: Execution Plan 1: - https:/

Re: comparison between 2 execution plans

Further information is These plans were generated by the EXPLAIN ANALYZE command, and the time of plan 1 (Postgresql 10.1 ) was 4.7 minutes and plan 2 (postgresql 9.5 changed) was 2.95 minutes. 2018-05-05 6:26 GMT-07:00 Neto pr : > Dear all > > Could you help me understand these two execution p

comparison between 2 execution plans

Dear all Could you help me understand these two execution plans for the same query (query 3 benchmark TPCH www.tpc.org/tpch), executed in two different environments of Postgresql, as described below: Execution Plan 1: - https://explain.depesz.com/s/Ughh - Postgresql version 10.1 (default) with ind