GSoC - Idea Discussion - Mailing list pgsql-hackers

From hitesh ramani
Subject GSoC - Idea Discussion
Date
Msg-id BAY176-W17BAB3012DDCD65F11AEE0DC000@phx.gbl
Whole thread Raw
Responses Re: GSoC - Idea Discussion
List pgsql-hackers
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 CUDA.

I have hardware to run CUDA and currently I'm at a point where I have almost integrated Postgres and CUDA. This opens up gates for a lot of features which can be optimized thru CUDA and parallel processing, though here I only want to focus on sorting, hence kind of feasible for the time period.

As I did some research, I found CUDA is more efficient in not just the parallel performance but data transfer latency too. My idea is to create a branch of Postgres with the CUDA integrated code.

For the feasibility, I guess it's very much feasible because I've almost integrated CUDA execution and the code needs to be optimized as per CUDA.

Please give in your valuable suggestions and views on this.

Thanks and Regards,
Hitesh Ramani

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: INSERT ... ON CONFLICT IGNORE (and UPDATE) 3.0
Next
From: Peter Geoghegan
Date:
Subject: Re: Using 128-bit integers for sum, avg and statistics aggregates