PGSpider extension 1.0.0 is released

From: Toshiba via PostgreSQL Announce <announce-noreply(at)postgresql(dot)org>
To: PostgreSQL Announce <pgsql-announce(at)lists(dot)postgresql(dot)org>
Subject: PGSpider extension 1.0.0 is released
Date: 2022-06-23 05:52:59
Message-ID: 165596357935.879890.18328530387523886665@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-announce

We have released PGSpider extension v1.0.0.

This is an extension to construct data virtualization engine by PostgreSQL.
As compared to the first release of 10 months ago, the quality and connectivity of FDWs were improved.
Please refer README.md for supporting FDWs.

The main feature is

* Node partitioned table
User can get records in multi tables on some data sources by one SQL easily.
If there are some tables with similar schema in each data source, PGSpider can view them as a single virtual table.

* Parallel processing
PGSpider executes queries and fetches results from child nodes in parallel.
PGSpider expands a virtual table to child tables, access corresponding datasource of each child table on some worker processes.

* Pushdown
PGSpider can pushdown WHERE clause and aggregation functions to data sources.
The shippability depends on datasource FDW.

This is developed by Toshiba Software Engineering & Technology Center.
Source repository : https://github.com/pgspider/pgspider_ext

Best Regards,
TAIGA Katayama

Browse pgsql-announce by date

  From Date Subject
Next Message Timescale via PostgreSQL Announce 2022-06-23 16:17:25 Timescale's 2022 State of PostgreSQL Survey Is Now Open!
Previous Message Toshiba via PostgreSQL Announce 2022-06-23 05:52:48 JDBC FDW 0.2.0 release