Learn more about Open Source Summit Japan and register here
Back To Schedule
Friday, June 2 • 16:50 - 17:30
Intelligent Storage: SQL Execution on GPU Closely Connected with SSD - KaiGai Kohei, PG-Strom Development Team

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
KaiGai Kohei presents a new feature built on PostgreSQL to accelerate analytic queries, with leverage of heterogeneous hardware. PostgreSQL has already allowed off-loading some CPU intensive SQL workloads onto GPU device, to utilize its multi-thousands cores to process tons of records. Not only massive parallel computing, GPU also has an interesting feature which runs peer-to-peer DMA from other PCIe device to GPU. It makes possible to load the data blocks of PostgreSQL on NVMe-SSD to GPU directly. Once data blocks get loaded, we already have a mechanism to run WHERE/JOIN/GROUP BY on GPU, then write back its execution results to host RAM. It is usually much smaller than raw data, thus less amount of records CPU must process. From the standpoint of applications, a couple of SSD and GPU look like an intelligent storage that understand and run SQL then returns minimum necessary data set.

avatar for KaiGai Kohei

KaiGai Kohei

Chief Architect, PG-Strom Development Team
KaiGai Kohei is lead developer of the PG-Strom project. He has more than ten years experiences around open source software development of Linux, PostgreSQL and so on. Especially, he has contributed some of core functionality of PostgreSQL on the area of security enhancement and pluggable... Read More →

Friday June 2, 2017 16:50 - 17:30 JST
Room 6