Re: [idea] table partition + hash join - Mailing list pgsql-hackers

From Amit Langote
Subject Re: [idea] table partition + hash join
Date
Msg-id 5577FE97.1090807@lab.ntt.co.jp
Whole thread Raw
In response to Re: [idea] table partition + hash join  (Atri Sharma <atri.jiit@gmail.com>)
List pgsql-hackers
On 2015-06-10 PM 05:53, Atri Sharma wrote:
> On Wed, Jun 10, 2015 at 2:16 PM, Amit Langote <Langote_Amit_f8@lab.ntt.co.jp
>> wrote:
> 
>>
>> Perhaps the qual needs to be pushed all the way down
>> to the Hash's underlying scan if that makes sense.
>>
> 
> And that is a Pandora's box of troubles IMHO unless done in a very careful
> manner.
> 

More appropriately, that's a predicate (should not have called it a qual)
derived from partitioning-optimization specific knowledge.

Thanks,
Amit




pgsql-hackers by date:

Previous
From: Atri Sharma
Date:
Subject: Re: [idea] table partition + hash join
Next
From: Andres Freund
Date:
Subject: Missing XLOG_DEBUG check in AdvanceXLInsertBuffer()?