Re: Cube extension improvement, GSoC

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Cube extension improvement, GSoC
Дата
Msg-id 518259B5.6030305@vmware.com
обсуждение исходный текст
Ответ на Cube extension improvement, GSoC  (Stas Kelvich <stanconn@gmail.com>)
Ответы Re: Cube extension improvement, GSoC
Список 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 по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: [PATCH] pgbench --throttle (submission 4)
Следующее
От: Shaun Thomas
Дата:
Сообщение: Re: high io BUT huge amount of free memory