Re: Cube extension improvement, GSoC - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Cube extension improvement, GSoC
Date
Msg-id 518259B5.6030305@vmware.com
Whole thread Raw
In response to Cube extension improvement, GSoC  (Stas Kelvich <stanconn@gmail.com>)
Responses Re: Cube extension improvement, GSoC
List 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
lowerright 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
compoundkey 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



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: [PATCH] pgbench --throttle (submission 4)
Next
From: Shaun Thomas
Date:
Subject: Re: high io BUT huge amount of free memory