heterodb/pg-strom

Health v2 · maintenance only

Flags: no_releases no_license

Adoption not part of the score

1408 stars · 174 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

PG-Strom is a PostgreSQL extension that accelerates SQL analytics and batch workloads using GPU devices, NVMe-SSD storage, and Apache Arrow columnar files. It transparently offloads scans, joins, and aggregations to the GPU, including GPUDirect SQL that reads data from NVMe storage directly to the GPU.

Use cases

• accelerate analytical SQL queries on PostgreSQL with a GPU
• run large-scale aggregations and batch processing faster
• query Apache Arrow columnar files via PostgreSQL foreign data wrapper
• read NVMe-SSD data directly into the GPU bypassing CPU and RAM
• offload WHERE-clause scans, joins, and GROUP BY to GPU cores
• speed up PostGIS spatial functions and GiST index searches on GPU

When to choose

• you have heavy analytics or batch SQL workloads on PostgreSQL and GPU hardware available
• you want transparent GPU acceleration without rewriting applications
• you need to aggregate or search very large datasets stored as Apache Arrow files
• your bottleneck is scan/join/aggregation throughput on big data

When to avoid

• your workload is mostly small OLTP transactions rather than analytics
• you have no NVIDIA GPU or NVMe-SSD hardware available
• you need a fully managed or cloud-native database solution
• you require frequent per-row updates on columnar Arrow data

Facets

library · maturity active

database gpu-computing search-engine databases analytics big-data gpu-computing self-hosted postgresql-extension gpu-acceleration sql-analytics apache-arrow gpudirect nvme-ssd columnar-storage linux gpu

Member repositories

For agents

markdown · JSON · MCP: product_card(name="heterodb/pg-strom")