Re: [HACKERS] path toward faster partition pruning - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: [HACKERS] path toward faster partition pruning
Date
Msg-id CAFjFpRd=cLFQNKgBd56PikJcqgP7SBCV7mqXEgZB3R_5BRR7WA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] path toward faster partition pruning  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
List pgsql-hackers
On Wed, Apr 11, 2018 at 2:52 PM, Amit Langote
<Langote_Amit_f8@lab.ntt.co.jp> wrote:

>>
>> I've attached a delta patch that applies to your v2 which does this.
>> Do you think it's worth doing?
>
> We can see check by inspection that individual values are in appropriate
> partitions, which is the point of having the inserts and the select just
> above the actual pruning related tests.  So, I'm not sure if adding the
> satisfies_hash_partition against each pruning tests adds much.

+1.

-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company


pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: [HACKERS] path toward faster partition pruning
Next
From: Suhal Vemu
Date:
Subject: Re: ERROR: invalid memory alloc request size 1073741824