Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mQU9q-0003rp-MZ for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Sep 2021 12:36:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mQU9p-0005eD-L5 for pgsql-bugs@arkaria.postgresql.org; Wed, 15 Sep 2021 12:36:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mQU9p-0005e5-EI for pgsql-bugs@lists.postgresql.org; Wed, 15 Sep 2021 12:36:57 +0000 Received: from forward500p.mail.yandex.net ([77.88.28.110]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mQU9m-0000ct-2e for pgsql-bugs@lists.postgresql.org; Wed, 15 Sep 2021 12:36:56 +0000 Received: from sas1-d5a499063e09.qloud-c.yandex.net (sas1-d5a499063e09.qloud-c.yandex.net [IPv6:2a02:6b8:c08:793:0:640:d5a4:9906]) by forward500p.mail.yandex.net (Yandex) with ESMTP id C99C2F020F2; Wed, 15 Sep 2021 15:36:49 +0300 (MSK) Received: from 2a02:6b8:c08:b516:0:640:6059:effb (2a02:6b8:c08:b516:0:640:6059:effb [2a02:6b8:c08:b516:0:640:6059:effb]) by sas1-d5a499063e09.qloud-c.yandex.net (mxback/Yandex) with HTTP id maWW891E1qM1-anEKQNFV; Wed, 15 Sep 2021 15:36:49 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zsrv.org; s=mail; t=1631709409; bh=u67tW0jkJ5TlKUNu8gfawvVztkIUjDofSTIvrxFTn5U=; h=References:Date:Message-Id:Cc:Subject:In-Reply-To:To:From; b=beYekLbAoWt/eSG+QFrSqrVH8UvrlKJMhRIF8ZFYQCztuDCvGJe6zqcNGw4qfrWt7 RLvdJ0hIK1wToXlsr/QvT3L/U2Q0COZVUrLj47S48u7GedXGVI5OcUSr1CgR4+uh7X GWlUBFhxtFumyrLwewe14tZWTb6Ae0RgQeNTiCYg= Authentication-Results: sas1-d5a499063e09.qloud-c.yandex.net; dkim=pass header.i=@zsrv.org Received: by sas1-6059effbd848.qloud-c.yandex.net with HTTP; Wed, 15 Sep 2021 15:36:48 +0300 From: Sergei Kornilov To: Yudianto Prasetyo , Peter Smith Cc: PostgreSQL mailing lists In-Reply-To: References: Subject: Re: bugs or my fault MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Wed, 15 Sep 2021 15:36:48 +0300 Message-Id: <189541631708874@mail.yandex.ru> Content-Transfer-Encoding: 7bit Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello > from the document, I think the determinant of each row in the partition is the residual value (partition key divided by the specified modulus) No, the hash from partition key is used, not partition key itself. (How to divide text "hello!" by the specified modulus?) regards, Sergei