Re: Using the GPU

Alejandro Torras wrote:
> Billings, John wrote:
>> Does anyone think that PostgreSQL could benefit from using the video
>> card as a parallel computing device?  I'm working on a project using
>> Nvidia's CUDA with an 8800 series video card to handle non-graphical
>> algorithms.  I'm curious if anyone thinks that this technology could
>> be used to speed up a database?  If so which part of the database,
>> and what kind of parallel algorithms would be used?
>>
>
> Looking at nvidia's cuda homepage
> (http://developer.nvidia.com/object/cuda.html), I see that the
> parallel bitonic sorting could be used instead of
> qsort/heapsort/mergesort (I don't know which is used)
>
I think that the function cublasIsamax() explained at
http://developer.download.nvidia.com/compute/cuda/0_8/NVIDIA_CUBLAS_Library_0.8.pdf
can be used to find the maximum of a single precision vector, but
according with a previous post of Alexander Staubo, this function is
best suited for fixed-length tuple values.

But could the data be separated into two zones, one for varying-length
data and other for fixed-length data?
With this approach fixed-length data may be susceptible for more and
deeper optimizations like parallelization processing.

--
Alejandro Torras