Re: Partition by hash formula

2020-03-20 Thread Laurenz Albe
On Fri, 2020-03-20 at 12:50 +0300, Vlad Bokov wrote: > recently I read > https://blog.dbi-services.com/hash-partitioning-in-postgresql-11/ > and reproduced steps from the, which gave exact same count outcome, > which made me think > hashing is a pure function. > > Examined the data I saw following

Partition by hash formula

2020-03-20 Thread Vlad Bokov
Hello, recently I read https://blog.dbi-services.com/hash-partitioning-in-postgresql-11/ and reproduced steps from the, which gave exact same count outcome, which made me think hashing is a pure function. Examined the data I saw following distribution: dept_1: 1,14,39...; dept_2: 3,11,21...; dept