On Sun, Apr 01, 2018 at 03:48:07PM +0300, Konstantin Knizhnik wrote:
> Attach please find patch with first prototype implementation. It
> provides about 3.14 times improvement of performance at most of TPC-H
> queries.
Congratulations in finding a patch able to improve all workloads of
Postgres i
> 2 апр. 2018 г., в 16:57, Ashutosh Bapat
> написал(а):
> On Mon, Apr 2, 2018 at 3:49 AM, Marko Tiikkaja wrote:
>>
>> I'm a little worried about the fact that even with this model we're still
>> limited to only two dimensions. That's bound to cause problems sooner or
>> later.
> How about a
On Mon, Apr 2, 2018 at 3:49 AM, Marko Tiikkaja wrote:
> On Sun, Apr 1, 2018 at 3:48 PM, Konstantin Knizhnik
> 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
>> c
On Sun, Apr 1, 2018 at 3:48 PM, Konstantin Knizhnik <
k.knizh...@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 Sun, Apr 01, 2018 at 03:48:07PM +0300, Konstantin Knizhnik wrote:
> Hi hackers,
>
> Vertical (columnar) storage mode is most optimal for analytic and this is why
> it is widely used in databases oriented on OLAP, such as Vertica,
> HyPer,KDB,...
> In Postgres we have cstore extension which is
Hi!
On Sun, Apr 1, 2018 at 3:48 PM, Konstantin Knizhnik <
k.knizh...@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, ... an
Great Idea !
thank you Konstantin
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
Hi, Konstantin!
Thank you for working on new pluggable storage API.
Your patch in attachment is 505 bytes and contains only diff from explain.c. Is
it right?
01.04.2018, 15:48, "Konstantin Knizhnik" :
> Hi hackers,
>
> Vertical (columnar) storage mode is most optimal for analytic and this is wh
Hi hackers,
Vertical (columnar) storage mode is most optimal for analytic and this is why
it is widely used in databases oriented on OLAP, such as Vertica, HyPer,KDB,...
In Postgres we have cstore extension which is not able to provide all benefits
of vertical model because of lack of support o
