PostgreSQL: High-Performance SQL Cluster Engine PGSpider 4.0.0 released

NewsBot · 26 December 2023 17:05

A new PostgreSQL blog post/announcement has been posted!

We have just released PGSpider v4.0.0.
This version is based on PostgreSQL 16 and fixed some bugs.

PGSpider is High-Performance SQL Cluster Engine for distributed big data.
PGSpider can access a number of data sources using Foreign Data Wrapper(FDW) and retrieves the distributed data source vertically.
Usage of PGSpider is the same as PostgreSQL. You can use any client applications such as libpq and psql.

PGSpider supports following features :

Multi-Tenant :
User can get records in multi tables by one SQL easily. If there are tables with similar schema in each data source, PGSpider can view them as a single virtual table: We call it as Multi-Tenant table.
About an insertion for Multi-tenant table, data is inserted into data sources distributedly by round robin algorithm (This specification was improved from the previous version).

Parallel processing :
PGSpider executes queries and fetches results from child nodes in parallel.<...

Get the full details here: https://www.postgresql.org/about/news/high-performance-sql-cluster-engine-pgspider-400-released-2774/