HASH partitioning not working properly

2020-06-18 Thread Srinivasa T N
Hi, After seeing the below, I feel partitioning is not working properly or it maybe case that my understanding is wrong. Can somebody explain me what is happening? postgres=# create table busbar_version (objectid int, ver_id int) partition by hash(ver_id); CREATE TABLE postgres=# CREATE TABLE

Re: HASH partitioning not working properly

2020-06-18 Thread David Rowley
On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote: >After seeing the below, I feel partitioning is not working properly or it > maybe case that my understanding is wrong. Can somebody explain me what is > happening? > postgres=# select * from busbar_version6; > objectid | ver_id > ---

Re: HASH partitioning not working properly

2020-06-18 Thread Srinivasa T N
On Fri, Jun 19, 2020 at 11:44 AM David Rowley wrote: > On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote: > >After seeing the below, I feel partitioning is not working properly > or it maybe case that my understanding is wrong. Can somebody explain me > what is happening? > > > postgres=# s

Re: HASH partitioning not working properly

2020-06-19 Thread Laurenz Albe
On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T N wrote: > On Fri, Jun 19, 2020 at 11:44 AM David Rowley wrote: > > On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote: > > >After seeing the below, I feel partitioning is not working properly or > > > it maybe case that my understanding is wrong

Re: HASH partitioning not working properly

2020-06-19 Thread Srinivasa T N
On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe wrote: > On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T N wrote: > > On Fri, Jun 19, 2020 at 11:44 AM David Rowley > wrote: > > > On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote: > > > >After seeing the below, I feel partitioning is not workin

Re: HASH partitioning not working properly

2020-06-19 Thread Amul Sul
On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N wrote: > > On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe > wrote: >> >> On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T N wrote: >> > On Fri, Jun 19, 2020 at 11:44 AM David Rowley wrote: >> > > On Fri, 19 Jun 2020 at 17:42, Srinivasa T N wrote: >> >

Re: HASH partitioning not working properly

2020-06-19 Thread Srinivasa T N
On Fri, Jun 19, 2020 at 3:09 PM Amul Sul wrote: > On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N wrote: > > > > On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe > wrote: > >> > >> On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T N wrote: > >> > On Fri, Jun 19, 2020 at 11:44 AM David Rowley > wrote:

Re: HASH partitioning not working properly

2020-06-19 Thread Amul Sul
On Fri, Jun 19, 2020 at 3:50 PM Srinivasa T N wrote: > > > > On Fri, Jun 19, 2020 at 3:09 PM Amul Sul wrote: >> >> On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N wrote: >> > >> > On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe >> > wrote: >> >> >> >> On Fri, 2020-06-19 at 12:12 +0530, Srinivasa T

Re: HASH partitioning not working properly

2020-06-19 Thread Srinivasa T N
On Fri, Jun 19, 2020, 5:45 PM Amul Sul wrote: > On Fri, Jun 19, 2020 at 3:50 PM Srinivasa T N wrote: > > > > > > > > On Fri, Jun 19, 2020 at 3:09 PM Amul Sul wrote: > >> > >> On Fri, Jun 19, 2020 at 1:28 PM Srinivasa T N > wrote: > >> > > >> > On Fri, Jun 19, 2020 at 12:34 PM Laurenz Albe < >

Re: HASH partitioning not working properly

2020-06-19 Thread Laurenz Albe
On Fri, 2020-06-19 at 13:27 +0530, Srinivasa T N wrote: > > > How can I see the output of hash function that is used internally? > > > > In the case of "integer", the hash function is "pg_catalog"."hashint4". > > I guess output formatting is wrong, any help? > > postgres=# select pg_catalog.hashi