[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: postgres 11.0 partition table works unexpected in update
From:       Amit Langote <amitlangote09 () gmail ! com>
Date:       2018-10-24 14:26:33
Message-ID: CA+HiwqE6nWnU=EKPjpXcf4vAhLHz7gG_geHJ3fiSC7xf5wM+Jw () mail ! gmail ! com
[Download RAW message or body]

On Wed, Oct 24, 2018 at 11:23 PM Amit Langote <amitlangote09@gmail.com> wro=
te:
> On Wed, Oct 24, 2018 at 8:09 PM =E5=BC=A0=E5=BF=83=E7=81=B5 <zhangsilly@g=
mail.com> wrote:
> > BTW: SELECT 14211 % 128 was 3, why record of HASH column user_id 14211 =
data in partition of 114?
>
> Hash partitioning doesn't apply modulus 3 directly to the value
> '14211'.  It first computes its hash using the hashing function for
> bigint type and then applies the modulus.

Oops, I meant to say "doesn't apply modulus 128 directly to the value 14211=
".

Thanks,
Amit

[prev in list] [next in list] [prev in thread] [next in thread]