PGSpider

Overview

PGSpider is ranked #12 of 23 in data federation software on Specifiction. It runs on Linux, Self-hosted. There is a free plan.

Compared on data federation software

Self-hosted

Yesgithub.com

SQL querying

Yesgithub.com

Facts

Purpose

PGSpider is a SQL cluster engine for distributed big data that accesses data sources through Foreign Data Wrappers.github.com · 4 Oct 2026

Virtual tables

It can present similarly structured tables from multiple data sources as one Multi-Tenant virtual table queried with a single SQL statement.github.com · 4 Oct 2026

Parallel queries

PGSpider runs queries and fetches results from child nodes in parallel.github.com · 4 Oct 2026

Pushdown

It pushes WHERE clauses and aggregation functions down to child nodes, and supports AVG, STDDEV, and VARIANCE on Multi-Tenant tables.github.com · 4 Oct 2026

Data modification

Multi-Tenant tables support INSERT, UPDATE, and DELETE, as well as bulk INSERT using a batch_size option.github.com · 4 Oct 2026

Data sources

The README demonstrates PostgreSQL and SQLite and lists PostgreSQL, MySQL, Oracle, GridDB, PGSpider, InfluxDB v2.0, and Amazon S3 Parquet storage for migration.github.com · 4 Oct 2026

Cloud transfer

Data Compression Transfer sends compressed data through a Cloud Function and requires a pgspider_fdw relay server with endpoint and relay options.github.com · 4 Oct 2026

Client compatibility

PGSpider uses PostgreSQL-like operation and documents use with client applications such as libpq and psql.github.com · 4 Oct 2026

Deployment

The README documents building from source and installing to /usr/local/pgspider.github.com · 4 Oct 2026

License

The included license permits use, copying, modification, and distribution without a fee, and disclaims warranties and an obligation to provide support or updates.github.com · 4 Oct 2026

Modification limitation

RETURNING, WITH CHECK OPTION, and ON CONFLICT are unsupported with modification, and foreign-partition COPY and modification are unsupported.github.com · 4 Oct 2026

Transaction limitation

The README recommends running modifications in auto-commit mode because modified data may not be readable within a transaction and non-auto-commit changes may be inconsistent.github.com · 4 Oct 2026

Tree feature status

The README says the tree-structure feature is not tested enough and is in beta.github.com · 4 Oct 2026

Where it ranks on Specifiction

• Best Data Federation Software in 2026#12 of 23

Sources

• github.com/pgspider/pgspider· checked 4 Oct 2026
• github.com/pgspider/pgspider/blob/master/LICENSE· checked 4 Oct 2026