Re: Cube extension improvement, GSoC

From: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
To: Stas Kelvich <stanconn(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Cube extension improvement, GSoC
Date: 2013-05-02 12:19:01
Message-ID: 518259B5.6030305@vmware.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Stas, and sorry for the late response.

On 23.03.2013 01:10, Stas Kelvich wrote:
> * Adding point data type support to the cube extension in order to avoid storing of coincident upper left and lower right vertices, which may reduce the volume that leaf nodes occupy almost twice.

Makes sense. I think it would be possible to implement this as an
optimization to existing cube data type, so that a cube that is actually
a point is simply stored more efficiently. Ie. set a flag in the NDBOX
struct indicating that the cube is a point, and omit the second set of
coordinates if that's set.

> * Learning cube extension to store dimensions with different data types. Such index would be good alternative to compound key B-Tree multi-index (suitable for diapason queries and data ordering).

You mean, a cube containing something else than floats? I don't think we
want to explode the number of datatypes by doing that, casting between
them could be problematic. But I wonder if you could add cube-like
operators for arrays. We already have support for arrays of any
datatype, and any number of dimensions. That seems awfully lot like what
the cube extension does.

- Heikki

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2013-05-02 12:27:28 Re: In progress INSERT wrecks plans on table
Previous Message Fabien COELHO 2013-05-02 12:09:51 [PATCH] pgbench --throttle (submission 4)