PostgreSQL: High-Performance SQL Cluster Engine PGSpider 2.0.0 released

NewsBot · 27 December 2021 04:05

A new PostgreSQL blog post/announcement has been posted!

We have just released PGSpider v2.0.0.

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.

This release improves following items :

Publish full source code

The old version was reqired to apply the patch to PostgreSQL

Based on PostgreSQL 14.0

Pushdown SQL function in the target list

Pushdown JOIN if all tables in a query are located in a single data source

Change the program name ('pgspider') and default port number(4813)

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 a...

Get the full details here: PostgreSQL: High-Performance SQL Cluster Engine PGSpider 2.0.0 released