PGSpider

Spec sheet

Purpose

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

Deployment

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

License

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

Client compatibility

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

Cloud transfer

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

Data modification

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

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.Read 4 Oct 2026 · github.com

Modification limitation

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

Parallel queries

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

Pushdown

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

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.Read 4 Oct 2026 · github.com

Tree feature status

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

Virtual tables

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

Plans and prices

Every PGSpider plan and price →

Where Specifiction places it

• Data Federation Software#12 of 247.6