Re: Column lookup in a row performance

2019-04-03 Thread Павлухин Иван
Tom, thanks for your answer. It definitely makes a picture in my mind more clear. вт, 2 апр. 2019 г. в 18:41, Tom Lane : > > =?UTF-8?B?0J/QsNCy0LvRg9GF0LjQvSDQmNCy0LDQvQ==?= writes: > >> (1) Backwards compatibility, and (2) it's not clear that a different > >> layout would be a win for all cases.

Re: Column lookup in a row performance

2019-04-02 Thread Tom Lane
=?UTF-8?B?0J/QsNCy0LvRg9GF0LjQvSDQmNCy0LDQvQ==?= writes: >> (1) Backwards compatibility, and (2) it's not clear that a different >> layout would be a win for all cases. > I am curious regarding (2), for my understanding it is good to find > out at least one case when layout with lengths/offsets i

Re: Column lookup in a row performance

2019-04-01 Thread Павлухин Иван
Tom, Thank you. > (1) Backwards compatibility, and (2) it's not clear that a different > layout would be a win for all cases. I am curious regarding (2), for my understanding it is good to find out at least one case when layout with lengths/offsets in a header will be crucially worse. I will be h

Re: Column lookup in a row performance

2019-03-30 Thread Tom Lane
=?UTF-8?B?0J/QsNCy0LvRg9GF0LjQvSDQmNCy0LDQvQ==?= writes: > Does anyone know why the format is still the same? (1) Backwards compatibility, and (2) it's not clear that a different layout would be a win for all cases. regards, tom lane

Column lookup in a row performance

2019-03-29 Thread Павлухин Иван
Hi PostgresSQL developers, I asked my question already on pgsql-general list and did not find an explanation. Below is the question mainly copied from [0]. I am learning deeply how tuples are organized and column values are accessed in different databases. As far as undertood postgres does n