[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-announce
Subject: High-Performance SQL Cluster Engine PGSpider 2.0.0 released
From: Toshiba via PostgreSQL Announce <announce-noreply () postgresql ! org>
Date: 2021-12-27 2:31:37
Message-ID: 164057229773.21665.5057534322625356832 () wrigleys ! postgresql ! org
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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 as a single virtual table: \
We call it as Multi-Tenant table.
Parallel processing :
PGSpider executes queries and fetches results from child nodes in parallel.
PGSpider expands Multi-Tenant table to child tables, creates new threads for each \
child table to access corresponding data source.
Pushdown :
WHERE clause and aggregation functions are pushed down to child nodes. Pushdown to \
Multi-tenant tables occur error when AVG, STDDEV and VARIANCE are used. PGSPider \
improves this error, PGSpider can execute them. JOIN also pushed down if all tables \
in a query are located in a single data source.
This is developed by Toshiba Software Engineering & Technology Center.
Please see the repository for details, and tell us feedback.
Source repository : https://github.com/pgspider/pgspider
Best Regards,
TAIGA Katayama
[Attachment #5 (text/html)]
<!doctype html>
<html>
<head>
<meta name="viewport" content="width=device-width">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>High-Performance SQL Cluster Engine PGSpider 2.0.0 released</title>
<style>
@media only screen and (max-width: 620px) {
table[class=body] h1 {
font-size: 28px !important;
margin-bottom: 10px !important;
}
table[class=body] p,
table[class=body] ul,
table[class=body] ol,
table[class=body] td,
table[class=body] span,
table[class=body] a {
font-size: 16px !important;
}
table[class=body] .wrapper,
table[class=body] .article {
padding: 10px !important;
}
table[class=body] .content {
padding: 0 !important;
}
table[class=body] .container {
padding: 0 !important;
width: 100% !important;
}
table[class=body] .main {
border-left-width: 0 !important;
border-radius: 0 !important;
border-right-width: 0 !important;
}
table[class=body] .btn table {
width: 100% !important;
}
table[class=body] .btn a {
width: 100% !important;
}
table[class=body] .img-responsive {
height: auto !important;
max-width: 100% !important;
width: auto !important;
}
}
@media all {
.ExternalClass {
width: 100%;
}
.ExternalClass,
.ExternalClass p,
.ExternalClass span,
.ExternalClass font,
.ExternalClass td,
.ExternalClass div {
line-height: 100%;
}
.apple-link a {
color: inherit !important;
font-family: inherit !important;
font-size: inherit !important;
font-weight: inherit !important;
line-height: inherit !important;
text-decoration: none !important;
}
#MessageViewBody a {
color: inherit;
text-decoration: none;
font-size: inherit;
font-family: inherit;
font-weight: inherit;
line-height: inherit;
}
.btn-primary table td:hover {
background-color: #34495e !important;
}
.btn-primary a:hover {
background-color: #34495e !important;
border-color: #34495e !important;
}
}
</style>
</head>
<body class="" style="background-color: #f6f6f6; font-family: sans-serif; \
-webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4; margin: 0; \
padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%;"> <table \
border="0" cellpadding="0" cellspacing="0" class="body" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; \
background-color: #f6f6f6;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> <td class="container" style="font-family: sans-serif; font-size: \
14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580px; padding: \
10px; width: 580px;">
<div class="content" style="box-sizing: border-box; display: block; Margin: \
0 auto; max-width: 580px; padding: 10px;">
<span class="preheader" style="color: transparent; display: none; height: \
0; max-height: 0; max-width: 0; opacity: 0; overflow: hidden; mso-hide: all; \
visibility: hidden; width: 0;"></span> <table class="main" style="border-collapse: \
separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: \
#ffffff; border-radius: 3px;">
<tr>
<td class="wrapper" style="font-family: sans-serif; font-size: 14px; \
vertical-align: top; box-sizing: border-box; padding: 20px;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td style="font-family: sans-serif; font-size: 14px; \
vertical-align: top;">
<div>
<h1 style="color: #000; font-family: sans-serif; line-height: 1.4; margin: 0; \
margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: \
center">High-Performance SQL Cluster Engine PGSpider 2.0.0 released</h1> </div>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">We have just released PGSpider v2.0.0. </p> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">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. <br/> Usage of \
PGSpider is the same as PostgreSQL. You can use any client applications such as libpq \
and psql. </p> <p style="font-family: sans-serif; font-size: 14px; font-weight: \
normal; margin: 0; margin-bottom: 15px">This release improves following items : </p> \
<ul style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px"> <li style="list-style-position: inside; margin-left: \
5px">Publish full source code </li> <li style="list-style-position: inside; \
margin-left: 5px">The old version was reqired to apply the patch to PostgreSQL </li> \
<li style="list-style-position: inside; margin-left: 5px">Based on PostgreSQL 14.0 \
</li> <li style="list-style-position: inside; margin-left: 5px">Pushdown SQL function \
in the target list </li> <li style="list-style-position: inside; margin-left: \
5px">Pushdown JOIN if all tables in a query are located in a single data source </li> \
<li style="list-style-position: inside; margin-left: 5px">Change the program name \
('pgspider') and default port number(4813) </li> </ul>
<p style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">PGSpider supports following features : </p> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Multi-Tenant : <br/> 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. </p> <p \
style="font-family: sans-serif; font-size: 14px; font-weight: normal; margin: 0; \
margin-bottom: 15px">Parallel processing : <br/> PGSpider executes queries and \
fetches results from child nodes in parallel. <br/> PGSpider expands Multi-Tenant \
table to child tables, creates new threads for each child table to access \
corresponding data source. </p> <p style="font-family: sans-serif; font-size: 14px; \
font-weight: normal; margin: 0; margin-bottom: 15px">Pushdown : <br/> WHERE clause \
and aggregation functions are pushed down to child nodes. Pushdown to Multi-tenant \
tables occur error when AVG, STDDEV and VARIANCE are used. PGSPider improves this \
error, PGSpider can execute them. JOIN also pushed down if all tables in a query are \
located in a single data source. </p> <p style="font-family: sans-serif; font-size: \
14px; font-weight: normal; margin: 0; margin-bottom: 15px">This is developed by \
Toshiba Software Engineering & Technology Center. <br/> Please see the repository \
for details, and tell us feedback. </p> <p style="font-family: sans-serif; font-size: \
14px; font-weight: normal; margin: 0; margin-bottom: 15px">Source repository : \
https://github.com/pgspider/pgspider </p> <p style="font-family: sans-serif; \
font-size: 14px; font-weight: normal; margin: 0; margin-bottom: 15px">Best \
Regards,<br/> TAIGA Katayama</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<div class="footer" style="clear: both; Margin-top: 10px; text-align: \
center; width: 100%;">
<table border="0" cellpadding="0" cellspacing="0" \
style="border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt; \
width: 100%;"> <tr>
<td class="content-block" style="font-family: sans-serif; \
vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-size: 12px; color: \
#999999; text-align: center;">
<span class="apple-link" style="color: #999999; font-size: 12px; \
text-align: center;"> This email was sent to you from Toshiba. It was delivered on \
their behalf by the PostgreSQL project. Any questions about the content of the \
message should be sent to Toshiba.
</span>
<br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mailinglist, \
for the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click the personal \
unsubscribe link that you can find in the headers of this email, or visit
<a href="https://lists.postgresql.org/unsubscribe/" style="color: #3498db; \
text-decoration: underline">https://lists.postgresql.org/unsubscribe/</a>.
</td>
</tr>
</table>
</div>
</div>
</td>
<td style="font-family: sans-serif; font-size: 14px; vertical-align: \
top;"> </td> </tr>
</table>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic