Re: Modyfication Sort Merge Join Alghoritm - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Modyfication Sort Merge Join Alghoritm
Date
Msg-id 52095C0F.5000605@agliodbs.com
Whole thread Raw
In response to Modyfication Sort Merge Join Alghoritm  (tubadzin <tubadzin@o2.pl>)
List pgsql-hackers
On 08/12/2013 01:31 PM, tubadzin wrote:
> Hi users.
> I want to sure, that is no this implementation in Postgresql:
> For Sorte Merge Join Alghoritm:
>  If the large input arrives sorted,
> g-join joins its pages with the buffer pool contents by strictly
> increasing join key values and the join output is also strictly
> sorted.

I'm not quite sure what you're asking.  We have a merge sort already,
and AFAIK it doesn't resort the input if it was sorted in an earlier step.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [BUGS] BUG #8335: trim() un-document behaviour
Next
From: Greg Stark
Date:
Subject: Re: killing pg_dump leaves backend process