Re: Performance difference in accessing differrent columns in aPostgres Table

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Performance difference in accessing differrent columns in aPostgres Table
Дата
Msg-id CAKJS1f_CrjvGYExtmzYzzUnD9XzcbFpo6R_FON2hewSHpqM1xg@mail.gmail.com
обсуждение исходный текст
Ответ на Performance difference in accessing differrent columns in a Postgres Table  (Dinesh Kumar <dns98944@gmail.com>)
Ответы Re: Performance difference in accessing differrent columns in a Postgres Table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
On 29 July 2018 at 17:38, Dinesh Kumar <dns98944@gmail.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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Dinesh Kumar
Дата:
Сообщение: Performance difference in accessing differrent columns in a Postgres Table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance difference in accessing differrent columns in a Postgres Table