Content-Type: multipart/mixed; boundary="===============0683770242929599977=="
MIME-Version: 1.0
Subject: High-Performance SQL Cluster Engine PGSpider 4.0.0 released
To: PostgreSQL Announce <pgsql-announce@lists.postgresql.org>
From: Toshiba via PostgreSQL Announce <announce-noreply@postgresql.org>
Reply-To: p-db@swc.toshiba.co.jp
Date: Tue, 26 Dec 2023 16:33:14 +0000
Message-ID: 
 <170360839495.1876498.14419640536238258785@wrigleys.postgresql.org>
Auto-Submitted: auto-generated
Archived-At: 
 <https://www.postgresql.org/message-id/170360839495.1876498.14419640536238258785%40wrigleys.postgresql.org>
Precedence: bulk

--===============0683770242929599977==
Content-Type: multipart/alternative;
 boundary="===============1402080737128973662=="
MIME-Version: 1.0

--===============1402080737128973662==
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable

We have just released PGSpider v4.0.0. =20
This version is based on PostgreSQL 16 and fixed some bugs.
=20
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. =20
Usage of PGSpider is the same as PostgreSQL. You can use any client applica=
tions such as libpq and psql.

PGSpider supports following features :=20

Multi-Tenant : =20
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 singl=
e virtual table: We call it as Multi-Tenant table. =20
About an insertion for Multi-tenant table, data is inserted into data sourc=
es distributedly by round robin algorithm (This specification was improved =
from the previous version).
=20
Parallel processing : =20
PGSpider executes queries and fetches results from child nodes in parallel.=
 =20
PGSpider expands Multi-Tenant table to child tables, creates new threads fo=
r each child table to access corresponding data source.
=20
Pushdown : =20
WHERE clause, aggregation functions, SQL function in the target list are pu=
shed down to child nodes.
JOIN is also pushed down if all tables in a query are located in a single d=
ata source. =20
Pushdown to Multi-tenant tables occur error when AVG, STDDEV and VARIANCE a=
re 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.
=20
This is developed by Toshiba Digital Innovation Technology Center. =20
Please see the repository for details, and tell us feedback.
=20
Source repository : [https://github.com/pgspider/pgspider](https://github.c=
om/pgspider/pgspider)=20
=20
Best Regards, =20
TAIGA Katayama
--===============1402080737128973662==
Content-Type: text/html; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


<!doctype html>
<html>
  <head>
    <meta name=3D"viewport" content=3D"width=3Ddevice-width">
    <meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3DUTF-8=
">
    <title>High-Performance SQL Cluster Engine PGSpider 4.0.0 released</tit=
le>
    <style>

    @media only screen and (max-width: 620px) {
      table[class=3Dbody] h1 {
        font-size: 28px !important;
        margin-bottom: 10px !important;
      }
      table[class=3Dbody] p,
            table[class=3Dbody] ul,
            table[class=3Dbody] ol,
            table[class=3Dbody] td,
            table[class=3Dbody] span,
            table[class=3Dbody] a {
        font-size: 16px !important;
      }
      table[class=3Dbody] .wrapper,
            table[class=3Dbody] .article {
        padding: 10px !important;
      }
      table[class=3Dbody] .content {
        padding: 0 !important;
      }
      table[class=3Dbody] .container {
        padding: 0 !important;
        width: 100% !important;
      }
      table[class=3Dbody] .main {
        border-left-width: 0 !important;
        border-radius: 0 !important;
        border-right-width: 0 !important;
      }
      table[class=3Dbody] .btn table {
        width: 100% !important;
      }
      table[class=3Dbody] .btn a {
        width: 100% !important;
      }
      table[class=3Dbody] .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=3D"" style=3D"background-color: #f6f6f6; font-family: sans-se=
rif; -webkit-font-smoothing: antialiased; font-size: 14px; line-height: 1.4=
; margin: 0; padding: 0; -ms-text-size-adjust: 100%; -webkit-text-size-adju=
st: 100%;">
    <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" class=3D"body" =
style=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace=
: 0pt; width: 100%; background-color: #f6f6f6;">
      <tr>
        <td style=3D"font-family: sans-serif; font-size: 14px; vertical-ali=
gn: top;">&nbsp;</td>
        <td class=3D"container" style=3D"font-family: sans-serif; font-size=
: 14px; vertical-align: top; display: block; Margin: 0 auto; max-width: 580=
px; padding: 10px; width: 580px;">
          <div class=3D"content" style=3D"box-sizing: border-box; display: =
block; Margin: 0 auto; max-width: 580px; padding: 10px;">


            <span class=3D"preheader" style=3D"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=3D"main" style=3D"border-collapse: separate; mso-t=
able-lspace: 0pt; mso-table-rspace: 0pt; width: 100%; background: #ffffff; =
border-radius: 3px;">


              <tr>
                <td class=3D"wrapper" style=3D"font-family: sans-serif; fon=
t-size: 14px; vertical-align: top; box-sizing: border-box; padding: 20px;">
                  <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" s=
tyle=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace:=
 0pt; width: 100%;">
                    <tr>
                      <td style=3D"font-family: sans-serif; font-size: 14px=
; vertical-align: top;">

<div>
<h1 style=3D"color: #000; font-family: sans-serif; line-height: 1.4; margin=
: 0; margin-bottom: 30px; font-size: 25px; font-weight: 300; text-align: ce=
nter">High-Performance SQL Cluster Engine PGSpider 4.0.0 released</h1>
</div>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">We have just released PGSpider v4.0.0.<br/>
This version is based on PostgreSQL 16 and fixed some bugs.</p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">PGSpider is High-Performance SQL Cluster En=
gine for distributed big data.<br/>
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 applica=
tions such as libpq and psql.</p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">PGSpider supports following features : </p>
<p style=3D"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 singl=
e virtual table: We call it as Multi-Tenant table.<br/>
About an insertion for Multi-tenant table, data is inserted into data sourc=
es distributedly by round robin algorithm (This specification was improved =
from the previous version).</p>
<p style=3D"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 fo=
r each child table to access corresponding data source.</p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">Pushdown :<br/>
WHERE clause, aggregation functions, SQL function in the target list are pu=
shed down to child nodes.
JOIN is also pushed down if all tables in a query are located in a single d=
ata source.<br/>
Pushdown to Multi-tenant tables occur error when AVG, STDDEV and VARIANCE a=
re 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=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">This is developed by Toshiba Digital Innova=
tion Technology Center.<br/>
Please see the repository for details, and tell us feedback.</p>
<p style=3D"font-family: sans-serif; font-size: 14px; font-weight: normal; =
margin: 0; margin-bottom: 15px">Source repository : <a href=3D"https://gith=
ub.com/pgspider/pgspider" style=3D"color: #3498db; text-decoration: underli=
ne">https://github.com/pgspider/pgspider</a> </p>
<p style=3D"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=3D"footer" style=3D"clear: both; Margin-top: 10px; t=
ext-align: center; width: 100%;">
              <table border=3D"0" cellpadding=3D"0" cellspacing=3D"0" style=
=3D"border-collapse: separate; mso-table-lspace: 0pt; mso-table-rspace: 0pt=
; width: 100%;">
                <tr>
                  <td class=3D"content-block" style=3D"font-family: sans-se=
rif; vertical-align: top; padding-bottom: 10px; padding-top: 10px; font-siz=
e: 12px; color: #999999; text-align: center;">
                    <span class=3D"apple-link" style=3D"color: #999999; fon=
t-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 shou=
ld be
sent to Toshiba.
</span>
		    <br><br>
You were sent this email as a subscriber of the <em>pgsql-announce</em> mai=
linglist, for
the content tag Related Open Source.
To unsubscribe from
further emails, or change which emails you want to receive, please click th=
e personal unsubscribe
link that you can find in the headers of this email, or visit
<a href=3D"https://lists.postgresql.org/unsubscribe/" style=3D"color: #3498=
db; text-decoration: underline">https://lists.postgresql.org/unsubscribe/</=
a>.

                  </td>
                </tr>
              </table>
            </div>

          </div>
        </td>
        <td style=3D"font-family: sans-serif; font-size: 14px; vertical-ali=
gn: top;">&nbsp;</td>
      </tr>
    </table>
  </body>
</html>

--===============1402080737128973662==--

--===============0683770242929599977==--