Re: Diagonal storage model

From: Marko Tiikkaja <marko(at)joh(dot)to>
To: Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Diagonal storage model
Date: 2018-04-01 22:19:28
Message-ID: CAL9smLDKaospgrYMxBkK7rWGDBxhZEOJhmF4BPU9ZpuGmkiVeA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Apr 1, 2018 at 3:48 PM, Konstantin Knizhnik <
k(dot)knizhnik(at)postgrespro(dot)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,...
>

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.

.m

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2018-04-02 01:42:47 Re: [HACKERS] path toward faster partition pruning
Previous Message Peter Geoghegan 2018-04-01 22:18:14 Re: WIP: Covering + unique indexes.