Re: [HACKERS] Possible regression with gather merge. - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] Possible regression with gather merge.
Date
Msg-id CA+TgmoYjcW1MYP99OEu5MPZPqEY2BecZJ+dDhSumi6m+xDGk3g@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Possible regression with gather merge.  (Rushabh Lathia <rushabh.lathia@gmail.com>)
List pgsql-hackers
On Wed, Mar 22, 2017 at 3:39 AM, Rushabh Lathia
<rushabh.lathia@gmail.com> wrote:
> Looking at the explain analyze output of both the plan, its clear that GM
> taking longer as its using external merge dist for the sort, where as
> another plan perform top-N heapsort. For normal sort path, it can consider
> the limit as bound, but for GM its not possible.

Right, good catch.  Committed.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: [HACKERS] PATCH: Make pg_stop_backup() archive wait optional
Next
From: Pavan Deolasee
Date:
Subject: Re: [HACKERS] Patch: Write Amplification Reduction Method (WARM)