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
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
> ---
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
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
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
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:
>> >
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:
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
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 <
>
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
10 matches
Mail list logo