Re: Does people favor to have matrix data type?

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Does people favor to have matrix data type?
Дата
Msg-id 5749C9D1.3060306@joeconway.com
обсуждение исходный текст
Ответ на Re: Does people favor to have matrix data type?  (Kouhei Kaigai <kaigai@ak.jp.nec.com>)
Ответы Re: Does people favor to have matrix data type?  (Kouhei Kaigai <kaigai@ak.jp.nec.com>)
Список pgsql-hackers
On 05/28/2016 07:12 AM, Kouhei Kaigai wrote:
> Sparse matrix! It is a disadvantaged area for the current array format.
>
> I have two ideas. HPC folks often split a large matrix into multiple
> grid. A grid is typically up to 1024x1024 matrix, for example.
> If a grid is consists of all zero elements, it is obvious we don't need
> to have individual elements on the grid.
> One other idea is compression. If most of matrix is zero, it is an ideal
> data for compression, and it is easy to reconstruct only when calculation.
>
>> Related to this, Tom has mentioned in the past that perhaps we should
>> support abstract use of the [] construct. Currently point finds a way to
>> make use of [], but I think that's actually coded into the grammar.
>>
> Yep, if we consider 2D-array is matrix, no special enhancement is needed
> to use []. However, I'm inclined to have own data structure for matrix
> to present the sparse matrix.

+1 I'm sure this would be useful for PL/R as well.

Joe

--
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Statement timeout
Следующее
От: Tom Lane
Дата:
Сообщение: pgdump/parallel.c: "aborting" flag is dead code