Re: Column lookup in a row performance

2019-03-26 Thread Павлухин Иван
xample an offset is equal to 'john' length. Storage space requirements looks very similar, does not they? ср, 27 мар. 2019 г. в 05:17, David Rowley : > > On Wed, 27 Mar 2019 at 04:16, Павлухин Иван wrote: > > It seems that an innodb layout is better at least for reading. So, it

Re: Column lookup in a row performance

2019-03-26 Thread Павлухин Иван
give significant benefits. пт, 22 мар. 2019 г. в 13:15, David Rowley : > > On Fri, 22 Mar 2019 at 19:13, Павлухин Иван wrote: > > I am learning deeply how tuples are organized and column values are > > accessed in different databases. As far as undertood postgres does not > &g

Column lookup in a row performance

2019-03-21 Thread Павлухин Иван
Hi PostgreSQL Community, I am learning deeply how tuples are organized and column values are accessed in different databases. As far as undertood postgres does not store all column positions in a tuple (e.g. in header or footer). In contrast MySQL InnoDB stores column lengths in a record header [1