From: | amul sul <sulamul(at)gmail(dot)com> |
---|---|
To: | Ashutosh Bapat <ashutosh(dot)bapat(at)enterprisedb(dot)com> |
Cc: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Thom Brown <thom(at)linux(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>, David Steele <david(at)pgmasters(dot)net>, Greg Stark <stark(at)mit(dot)edu>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [POC] hash partitioning |
Date: | 2017-10-10 11:07:40 |
Message-ID: | CAAJ_b96Vz278aAtxKd54bpf0QKA-QCi282vqFDs+R6a3cTZJBQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Tue, Oct 10, 2017 at 3:42 PM, Ashutosh Bapat
<ashutosh(dot)bapat(at)enterprisedb(dot)com> wrote:
> On Tue, Oct 10, 2017 at 3:32 PM, amul sul <sulamul(at)gmail(dot)com> wrote:
>
>>> + hash_part? true : key->parttypbyval[j],
>>> + key->parttyplen[j]);
>>> parttyplen is the length of partition key attribute, whereas what you want here
>>> is the length of type of modulus and remainder. Is that correct? Probably we
>>> need some special handling wherever parttyplen and parttypbyval is used e.g. in
>>> call to partition_bounds_equal() from build_joinrel_partition_info().
>>>
>>
>> Unless I am missing something, I don't think we should worry about parttyplen
>> because in the datumCopy() when the datatype is pass-by-value then typelen
>> is ignored.
>
> That's true, but it's ugly, passing typbyvalue of one type and len of other.
>
How about the attached patch(0003)?
Also, the dim variable is renamed to natts.
Regards,
Amul
Attachment | Content-Type | Size |
---|---|---|
0001-partition_bounds_copy-code-refactoring-v1.patch | application/octet-stream | 2.1 KB |
0002-hash-partitioning_another_design-v24.patch | application/octet-stream | 86.2 KB |
0003-Enable-partition-wise-join-support-v3.patch | application/octet-stream | 10.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2017-10-10 13:12:25 | Re: [JDBC] Channel binding support for SCRAM-SHA-256 |
Previous Message | Kyotaro HORIGUCHI | 2017-10-10 10:26:16 | More stats about skipped vacuums |