Re: [HACKERS] GSoC - Idea Discussion

2015-03-20 Thread Kouhei Kaigai
> KaiGai Kohei: > >It seems to me you are a little bit optimistic. > >Unlike CPU code, GPU-Sorting logic has to reference device memory space, > >so all the data to be compared needs to be transferred to GPU devices. > >Any pointer on host address space is not valid on GPU calculation. > >Amount of

Re: [HACKERS] GSoC - Idea Discussion

2015-03-20 Thread hitesh ramani
Hello devs, Thank you so much for the feedback, to answer to your questions: Tomas:>So you've created an array of 1M integers, and it's 7x faster on GPU >compared to pg_qsort(), correct? No, I meant general sorting, not on pg_qsort() >Well, it might surprise you, but PostgreSQL almost never sorts

Re: [HACKERS] GSoC - Idea Discussion

2015-03-19 Thread Kouhei Kaigai
> I think you reference the old branch in my personal repository. > Could you confirm the repository URL? Below is the latest. > https://github.com/pg-strom/devel > Sorry, it is not a problem of pg-strom repository. Please use the "custom_join" branch of the tree below: https://github.com/kaig

Re: [HACKERS] GSoC - Idea Discussion

2015-03-19 Thread Kouhei Kaigai
> > Could you please elaborate more why to choose CUDA, a nvidia-only > > technology, rather than OpenCL, supported by much wider range of > > companies and projects? Why do you consider OpenCL unsuitable? > > > > Not that CUDA is bad - it certainly works better in some scenarios, but > > this is a

Re: [HACKERS] GSoC - Idea Discussion

2015-03-19 Thread Alvaro Herrera
hitesh ramani wrote: > > You mention that you ran into issues with PG Strom. What issues? > > While I was trying to compile, I ran into the error "src/main.c:27:29: fatal > error: utils/ruleutils.h: No such file or directory", when I did make to the > branch of Postgres suggested in the descri

Re: [HACKERS] GSoC - Idea Discussion

2015-03-19 Thread Tomas Vondra
On 03/19/15 21:41, hitesh ramani wrote: Hello Tomas, > Could you please elaborate more why to choose CUDA, a nvidia-only > technology, rather than OpenCL, supported by much wider range of > companies and projects? Why do you consider OpenCL unsuitable? > > Not that CUDA is bad - it certa

Re: [HACKERS] GSoC - Idea Discussion

2015-03-19 Thread hitesh ramani
Hello Tomas, > Could you please elaborate more why to choose CUDA, a nvidia-only > technology, rather than OpenCL, supported by much wider range of > companies and projects? Why do you consider OpenCL unsuitable? > > Not that CUDA is bad - it certainly works better in some scenarios, but > this i

Re: [HACKERS] GSoC - Idea Discussion

2015-03-19 Thread Tomas Vondra
Hi Hitesh, On 18.3.2015 21:11, hitesh ramani wrote: > Hello devs, > > As stated earlier I was thinking to propose the integration of > Postgres and CUDA for faster execution of order by queries thru > optimizing the sorting code and sorting it with CUDA. I saw and tried > to run PG Strom and ran

[HACKERS] GSoC - Idea Discussion

2015-03-18 Thread hitesh ramani
Hello devs, As stated earlier I was thinking to propose the integration of Postgres and CUDA for faster execution of order by queries thru optimizing the sorting code and sorting it with CUDA. I saw and tried to run PG Strom and ran into issues. Moreover, PG Strom is implemented in OpenCL, not C