Re: help in analysis of execution plans

2018-05-05 Thread David Rowley
On 6 May 2018 at 03:16, Neto pr wrote: > Execution Plan 1 (query execution time 4.7 minutes): > - https://explain.depesz.com/s/Ughh > - Postgresql version 10.1 (default) with index on l_shipdate (table lineitem) > > Execution Plan 2 (query execution time 2.95 minutes): > - https://explain.depesz.c

Re: help in analysis of execution plans

2018-05-05 Thread Neto pr
Further information is that th Postgresql with modified source code, is that I modified some internal functions of cost (source code) and parameters in Postgresql.conf so that it is possible for the DBMS to differentiate cost of read (random and sequence) and write (random and sequence), this is be