From: Tom Lane <tgl@sss.pgh.pa.us>
To: Howard A. Chou <maingroup@yahoo.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Re: found a possible bug, modulus of an integer on a partition table appears to be wrong
Date: Sun, 05 Mar 2023 18:46:06 -0500
Message-ID: <3225216.1678059966@sss.pgh.pa.us> (raw)
In-Reply-To: <382692025.2538273.1678041938275@mail.yahoo.com>
References: <382692025.2538273.1678041938275.ref@mail.yahoo.com>
<382692025.2538273.1678041938275@mail.yahoo.com>
"Howard A. Chou" <maingroup@yahoo.com> writes:
> The remainder of 4, 6, 8 mod 2 should be 0. Instead of inserting into t1_0, all values were inserted into t1_1
You are confusing "modulus of the column value" with "modulus of
the hash of the column value". The latter is what determines
tuple routing in a hash-partitioned table.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, maingroup@yahoo.com, pgsql-bugs@lists.postgresql.org
Subject: Re: found a possible bug, modulus of an integer on a partition table appears to be wrong
In-Reply-To: <3225216.1678059966@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox