PostgreSQL扩展-PGStrom
2015-09-28 13:33:17 
阿炯
PG-Strom 是 PostgreSQL 的一个扩展，作为 custom-scan provider。PG-Strom 的目的是利用其庞大的并行执行能力，给GPU设备的一些 CPU 密集工作流。GPU 在处理器核心数量(通常是几百至几千)和更大的 RAM 带宽(通常比 CPU 大几倍容量)上有优势。在同时处理大规模数值操作的时候最高效。
PG-Strom 主要有两个特性：
原生 GPU 代码生成
异步和管道执行模型
PG-Strom is an extension of PostgreSQL, works as custom-scan provider. It was designed to off-load several CPU intensive workloads to GPU devices, to utilize its massive parallel execution capability. GPU has advantages on number of processor cores (usually several hundreds - thousands) and wider RAM bandwidth (usually multiple times larger capacity than CPU). It works most efficiently when it processes massive amount of numerical operations simultaneously.
要求：
PostgreSQL 9.5 devel
CUDA 7.0 或者更新版本
x86_64 Linux platform supported by CUDA
Parallel Approach
PG-Strom takes heterogeneous scale-up approach; that utilizes the most advantaged hardware according to the characteristics of the workloads. In other words, it assigns simple but massive amount of numerical calculation, that is too previous to run on CPU cores, on GPU devices.
最新版本：
项目主页：https://wiki.postgresql.org/wiki/PGStrom