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