Re: Performance difference in accessing differrent columns in a Postgres Table

2018-09-06 Thread Dinesh Kumar
Ok, will do that. Thanks a lot. On Wed, Sep 5, 2018 at 9:37 PM Jeff Janes wrote: > > > On Wed, Sep 5, 2018 at 12:00 PM Jeff Janes wrote: > >> On Wed, Sep 5, 2018 at 12:21 AM Dinesh Kumar wrote: >> >>> Hi All, >>> I was wondering whether th

Re: Performance difference in accessing differrent columns in a Postgres Table

2018-09-04 Thread Dinesh Kumar
Hi All, I was wondering whether the case is solved or still continuing. As a Postgres newbie, I can't understand any of the terms (JIT, tuple deformation) as you mentioned above. Please anyone let me know , what is the current scenario. Thanks, Dineshkumar. On Wed, Aug 1, 2018 at 8:51 PM Jeff Jan

Performance difference in accessing differrent columns in a Postgres Table

2018-07-28 Thread Dinesh Kumar
Hello All, I created a table with 200 bigint column, 200 varchar column. (Postgres 10.4) create table i200c200 ( pk bigint primary key, int1 bigint, int2 bigint,., int200 bigint, char1 varchar(255),.., char200 varchar(255)) ; Inserted values only in pk,int1,int200 columns with some rando