arrays of floating point numbers / linear algebra operations into the DB

Поиск
Список
Период
Сортировка
Искать
От
Enrico Sirola
Тема
arrays of floating point numbers / linear algebra operations into the DB
Дата
Msg-id
99409BD7-09FD-43BC-B66E-278E97AC5303@gmail.com
Список
Дерево обсуждения
arrays of floating point numbers / linear algebra operations into the DB Enrico Sirola <enrico.sirola@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Martijn van Oosterhout <kleptog@svana.org>
Re: arrays of floating point numbers / linear algebra operations into the DB Colin Wetherbee <cww@denterprises.org>
Re: arrays of floating point numbers / linear algebra operations into the DB Enrico Sirola <enrico.sirola@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Joe Conway <mail@joeconway.com>
Re: arrays of floating point numbers / linear algebra operations into the DB "Webb Sprague" <webb.sprague@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: arrays of floating point numbers / linear algebra operations into the DB "Webb Sprague" <webb.sprague@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: arrays of floating point numbers / linear algebra operations into the DB "Webb Sprague" <webb.sprague@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Ted Byers <r.ted.byers@rogers.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Ron Mayer <rm_pg@cheapcomplexdevices.com>
Re: arrays of floating point numbers / linear algebra operations into the DB "Webb Sprague" <webb.sprague@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Enrico Sirola <enrico.sirola@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB "Webb Sprague" <webb.sprague@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Enrico Sirola <enrico.sirola@gmail.com>
Re: arrays of floating point numbers / linear algebra operations into the DB Enrico Sirola <enrico.sirola@gmail.com>
Hello,
I'd like to perform linear algebra operations on float4/8 arrays.  
These tasks are tipically carried on using ad hoc optimized libraries  
(e.g. BLAS). In order to do this, I studied a bit how arrays are  
stored internally by the DB: from what I understood, arrays are  
basically a vector of Datum, and floating point numbers are stored by  
reference into Datums. At a first glance, this seem to close the  
discussion because in order to perform fast linear algebra operations,  
you need to store array items in consecutive memory cells.
What are the alternatives? Create a new specialized data type for  
floating point vectors?
Basically, the use-case is to be able to rescale, add and multiply  
(element-by-element)
vectors.

Thanks for your help,
e.



В списке pgsql-general по дате отправления
От: Nicolas KOWALSKI
Дата:
Сообщение: Re: problem with ORDER BY
От: Richard Huxton
Дата:
FAQ