On Tue, Jan 17, 2017 at 5:19 PM, Rushabh Lathia <rushabh.lathia@gmail.com> wrote: > > > > Here is the benchmark number which I got with the latest (v6) patch: > > - max_worker_processes = DEFAULT (8) > - max_parallel_workers_per_gather = 4 > - Cold cache environment is ensured. With every query execution - server is > stopped and also OS caches were dropped. > - The reported values of execution time (in ms) is median of 3 executions. > - power2 machine with 512GB of RAM > - With default postgres.conf >
You haven't mentioned scale factor used in these tests.
Oops sorry. Those results are for scale factor 10.