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
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
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. These plans
were generated by the EXPLAIN ANALYZE command, and the time of plan 1
was 4.7 minutes
