Re: Cube extension improvement, GSoC
От | Alexander Korotkov |
---|---|
Тема | Re: Cube extension improvement, GSoC |
Дата | |
Msg-id | CAPpHfduvs=KAY=zRVUw4Q3bAh_J_+ZeUe_o57xK4vo08jwGcNA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Cube extension improvement, GSoC (Heikki Linnakangas <hlinnakangas@vmware.com>) |
Ответы |
Re: Cube extension improvement, GSoC
|
Список | pgsql-hackers |
On Thu, May 2, 2013 at 4:19 PM, Heikki Linnakangas <hlinnakangas@vmware.com> wrote:
Alexander Korotkov.
* 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.
At least option for having float4 cube instead of foat8 cube seems reasonable for me, because of space economy payed by less accuracy.
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.
I think we have at least 3 data types more or less similar to cube.
1) array of ranges
2) range of arrays
3) 2d arrays
Semantically cube is most close to array or ranges. However array of ranges have huge storage overhead.
Also we can declare cube as domain on 2d arrays and declare operations of that domain.
------
With best regards,Alexander Korotkov.
В списке pgsql-hackers по дате отправления: