Re: Diagonal storage model
| От | Alexander Korotkov |
|---|---|
| Тема | Re: Diagonal storage model |
| Дата | |
| Msg-id | CAPpHfdvV=Xbr3Z18psMEkwF_-SJNT0hhA+asCK6S+jrnJi5DUA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Diagonal storage model (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>) |
| Список | pgsql-hackers |
Hi!
On Sun, Apr 1, 2018 at 3:48 PM, Konstantin Knizhnik <k.knizhnik@postgrespro.ru> wrote:
I want to announce new model, "diagonal storage" which combines benefits of both approaches.
The idea is very simple: we first store column 1 of first record, then column 2 of second record, ... and so on until we reach the last column.
After it we store second column of first record, third column of the second record,...
Sounds interesting. Could "diagonal storages" be applied twice? That is could we apply
diagonal transformation to the result of another diagonal transformation? I expect we
should get a "square diagonal" transformation...
Attach please find patch with first prototype implementation. It provides about 3.14 times improvement of performance at most of TPC-H queries.
Great, but with square diagonal transformation we should get 3.14^2 times improvement,
which is even better!
------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
В списке pgsql-hackers по дате отправления: