Re: [HACKERS] Gather Merge - Mailing list pgsql-hackers

From Rushabh Lathia
Subject Re: [HACKERS] Gather Merge
Date
Msg-id CAGPqQf06SuTEg-c2pVQMTcxOeBwjR_+hJx5mEfOUJNOHwhHDfw@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Gather Merge  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: [HACKERS] Gather Merge  (Kuntal Ghosh <kuntalghosh.2007@gmail.com>)
List pgsql-hackers


On Tue, Jan 17, 2017 at 6:44 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
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.
 

--
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com



--
Rushabh Lathia

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] Password identifiers, protocol aging and SCRAM protocol
Next
From: Mithun Cy
Date:
Subject: Re: [HACKERS] Cache Hash Index meta page.