Re: Diagonal storage model - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Diagonal storage model
Date
Msg-id F26CA0AB-F793-4CF5-B10B-B3AAE60EB7E6@yandex-team.ru
Whole thread Raw
In response to Re: Diagonal storage model  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers

> 2 апр. 2018 г., в 16:57, Ashutosh Bapat <ashutosh.bapat@enterprisedb.com> написал(а):
> On Mon, Apr 2, 2018 at 3:49 AM, Marko Tiikkaja <marko@joh.to> 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 3D storage model, whose first dimension gives horizontal
> view, second provides vertical or columnar view and third one provides
> diagonal view. It also provides capability to add extra dimensions to
> provide additional views like double diagonal view. Alas! it all
> collapses since I was late to the party.

BTW, MDX expression actually provides mulitidimensional result. They have COLUMNS, ROWS, PAGES, SECTIONS, CHAPTERS, and
AXIS(N)for those who is not satisfied with named dimensions. 

Best regards, Andrey Borodin.

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: [HACKERS] path toward faster partition pruning
Next
From: Etsuro Fujita
Date:
Subject: Re: [HACKERS] Add support for tuple routing to foreign partitions