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

From: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
To: Dinesh Kumar <dns98944(at)gmail(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance difference in accessing differrent columns in a Postgres Table
Date: 2018-07-29 21:53:55
Message-ID: CAKJS1f_CrjvGYExtmzYzzUnD9XzcbFpo6R_FON2hewSHpqM1xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 29 July 2018 at 17:38, Dinesh Kumar <dns98944(at)gmail(dot)com> wrote:
> I found performance variance between accessing int1 and int200 column which
> is quite large.

Have a look at slot_deform_tuple and heap_deform_tuple. You'll see
that tuples are deformed starting at the first attribute. If you ask
for attribute 200 then it must deform 1-199 first.

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2018-07-29 23:00:59 Re: Performance difference in accessing differrent columns in a Postgres Table
Previous Message Dinesh Kumar 2018-07-29 05:38:31 Performance difference in accessing differrent columns in a Postgres Table