CINXE.COM
Alibaba Cloud Community
<!DOCTYPE html> <html lang="en" class="sub-site-nav alicloud-header alicloud-footer"> <head> <meta charset="UTF-8"> <title>Alibaba Cloud Community</title> <link rel="shortcut icon" href="https://img.alicdn.com/tfs/TB1ugg7M9zqK1RjSZPxXXc4tVXa-32-32.png" /> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <meta name="keywords" content="" /> <meta name="description" content=""> <meta name="csrf-param" content="yunqi_csrf"/> <meta name="csrf-token" content="RACZ9RGCM1"/> <meta name="data-spm" content="a2c65"> <meta name="aplus-rhost-v" content="sg.mmstat.com"> <meta name="aplus-rhost-g" content="sg.mmstat.com"> <meta http-equiv="X-UA-Compatible" content="ie=edge"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/??alicloud-components/alicloud-ui3/0.0.7/acUI.css,alicloud-components/acApp/0.0.3/app.css,alicloud-components/i18n/0.0.29/css/en-us/index.css,alicloud-components/iconfont/0.0.7/product-icon.css"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/css/blogger.css"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/css/nav.css"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/fonts/iconfont.css"> <link rel="stylesheet" type="text/css" href="https://g.alicdn.com/ali-mod/b-alicloud-v3-bottom/0.0.19/index.css"> <link rel="stylesheet" type="text/css" href="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/fonts/iconfont.css"> <script src="//g.alicdn.com/??alicloud-components/kloud/0.0.31/vendor/requirejs/require.js,alicloud-components/kloud/0.0.1/scripts/vendor/jquery/jquery.min.js,alicloud-components/common/scripts/layout.js,alicloud-components/alicloud-ui3/0.0.7/acUI.js"></script> <script src="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/js/layout.js"></script> </head> <body data-spm="11461544"><script type="text/javascript"> (function (d) { var t=d.createElement("script");t.type="text/javascript";t.async=true;t.id="tb-beacon-aplus"; t.setAttribute("exparams","category=&userid=&aplus&yunid=&yunpk=&channel=&cps="); t.src="//g.alicdn.com/alilog/mlog/aplus_v2.js"; d.getElementsByTagName("head")[0].appendChild(t); })(document); </script> <div class="blog-nav"> <div class="container"> <div class="row"> <h1> Community </h1> <main class="blog-nav-center"> <a href="https://www.alibabacloud.com/blog/"> Blog </a> <a href="https://resource.alibabacloud.com/event/index"> Events </a> <a href="https://resource.alibabacloud.com/webinar/index.htm"> Webinars </a> <a href="https://community.alibabacloud.com/tags/type_blog-tagid_28404/"> Tutorials </a> <a href="https://www.alibabacloud.com/forum"> Forum </a> </main> <ul class="blog-nav-right"> <li class="search"><input type="text" placeholder="Search" id="search"> <i class="search-btn k-iconfont icon-sousuo1"></i> <div class="close-box"><img data-original="https://img.alicdn.com/tfs/TB1BIBBsbPpK1RjSZFFXXa5PpXa-24-24.png" data-toggle="lazy-loading" class="off" /><img data-original="https://img.alicdn.com/tfs/TB1vrJ2shnaK1RjSZFBXXcW7VXa-24-24.png" data-toggle="lazy-loading" class="on" /></div> </li> </ul> <div class="blog-nav-right-m"> <i class="k-iconfont icon-sousuo1 show-search"></i> <i class="show-more"></i> </div> </div> <div class="blog-nav-main-m"> <ol> <li><a href="https://community.alibabacloud.com">Blog</a></li> <li> <a href="https://resource.alibabacloud.com/event/index"> Events </a> </li> <li> <a href="https://resource.alibabacloud.com/webinar/index.htm"> Webinars </a> </li> <li> <a href="https://www.alibabacloud.com/getting-started/projects"> Tutorials </a> </li> <li> <a href="https://www.alibabacloud.com/forum"> Forum </a> </li> </ol> <div class="btn-box"> <a href="https://account.alibabacloud.com/register/register.htm?from_type=yqclub&oauth_callback=https%3A%2F%2Fcommunity.alibabacloud.com%2Fusers%2F5840330778398571%3Fdo%3Dlogin" class="free" style="display: block;"> Create Account </a> <a href="https://account.alibabacloud.com/login/login.htm?from_type=yqclub&oauth_callback=https%3A%2F%2Fcommunity.alibabacloud.com%2Fusers%2F5840330778398571%3Fdo%3Dlogin" class="login" style="display: block;"> Log In </a> </div> </div> <div class="container blog-nav-search-m"> <div class="blog-nav-search-m-top"> <input type="text" placeholder="Search" class="int-search"> <button> <i class="k-iconfont icon-sousuo1"></i> </button> <span> 脳 </span> </div> </div> </div> </div> <div class="wrap"> <div class="wrap-top"> <div class="container"> <dl class="row"> <dl> <dt> <img src="https://yqintl.alicdn.com/img_ab2363a06f15f1afc6dc7717ccd2769d.jpg" alt=""> </dt> <dd> <h2> digoal <button data-original-title="Master" data-container="body" data-toggle="popover" data-placement="top" data-trigger="hover"><img data-original="https://img.alicdn.com/tfs/TB1HHs2BgHqK1RjSZFPXXcwapXa-54-64.png" data-toggle="lazy-loading"></button> </h2> <h3> <span>13584</span> <b>Reputation</b> </h3> <p> PostgreSQL Evangelist. [My Git](https://github.com/digoal/blog/blob/master/README.md) </p> <a href="#" class="btn btn-default" data-islogin="false" data-uid="5840330778398571" data-isfollowed="false" id="follow-btn" rel="nofollow">Follow</a> </dd> </dl> </div> </div> <div class="new-nav"> <div class="container"> <div id="wrapper" class="row"> <div class="wrap-nav" id="scroller"> <span class="bg">Activities(50)</span> <span>Posts(286)</span> <span>Series(11)</span> <span class="areas">Areas of Expertise</span> <span class="following">Following</span> <span class="followers">Followers</span> </div> </div> </div> </div> <div class="wrap-main container"> <span class="hidden" id="pageLink_series" data-pagelink="/users/5840330778398571/album?p="></span> <span class="hidden" id="pageLink_activity" data-pagelink="/users/5840330778398571?p="></span> <span class="hidden" id="pageLink_article" data-pagelink="/users/5840330778398571/article/?p="></span> <span class="hidden" id="pageCount_article" data-pageCount="15"></span> <span class="hidden" id="pageCount_series" data-pageCount="1"></span> <span class="hidden" id="pageCount_acitvity" data-pageCount="3"></span> <div class="activities-main row on"> <div class="col-md-8 col-sm-8"> <div class="activities-main-left"> <div class="activities-main-left-list"> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/tips-for-executing-sql-statements-in-batch-which-is-better-gexec-or-dynamic-sql_601990">Tips for Executing SQL Statements in Batch: Which Is Better, gexec or Dynamic SQL?</a> </h3> <p> This article introduces two methods for executing SQL statements in batch: using the gexec convenient command in psql and using dynamic SQL. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">February 17, 2025</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 236 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/what-could-be-the-factor-leading-to-the-slow-execution-of-the-first-sql-statement_601984">What Could Be the Factor Leading to the Slow Execution of the First SQL Statement?</a> </h3> <p> The article introduces the factor contributing to the slow execution of the first SQL statement related to PostGIS library loading in PostgreSQL. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">February 13, 2025</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 309 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/how-to-remove-duplicate-and-similar-contents-in-vector-databases_601909">How to Remove Duplicate and Similar Contents in Vector Databases</a> </h3> <p> The article introduces the use of vector databases for similarity searches and deduplication. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">December 31, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 866 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/how-to-implement-parallelism-and-concurrency-control-queue-in-shell_601908">How to Implement Parallelism and Concurrency Control (Queue) in Shell</a> </h3> <p> This article introduces how to implement parallelism and concurrency control in the shell using GNU Parallel and a bash script. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">December 31, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 867 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/how-to-determine-whether-the-current-postgresql-database-is-in-a-consistent-state_601748">How to Determine Whether the Current PostgreSQL Database is in a Consistent State?</a> </h3> <p> This article introduces how to determine whether the current PostgreSQL database is in a consistent state. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">November 11, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 887 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/polardb-for-postgresql-%7C-retrieval-and-matching-degree-sorting-by-tags-on-blogs-and-websites_601209">PolarDB for PostgreSQL | Retrieval and Matching-Degree Sorting by Tags on Blogs and Websites</a> </h3> <p> This article focuses on how to use databases effectively, rather than how to manage database operations or develop database kernels. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">May 28, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,120 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/three-key-details-and-principles-of-postgresql-online-backup-%26-recovery_601208">Three Key Details and Principles of PostgreSQL Online Backup & Recovery</a> </h3> <p> This article discusses the process of online backup restoration and addresses three key questions regarding the recovery of database consistency. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">May 28, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 941 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/polardb-for-postgresql-%7C-database-performance-optimization-for-high-concurrency-queue-processing_601207">PolarDB for PostgreSQL | Database Performance Optimization for High-Concurrency Queue Processing</a> </h3> <p> This article describes the database optimization strategies and presents a demo illustrating how to boost database performance for queue processing tasks. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">May 28, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,231 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/implementing-postgresql-hook-stats-on-tables-with-full-scans-%26-corresponding-sqls_601193">Implementing PostgreSQL Hook: Stats on Tables with Full Scans & Corresponding SQLs</a> </h3> <p> This article provides a guide to implementing a PostgreSQL hook for tracking and gathering detailed statistics on tables undergoing full scans and their corresponding SQL statements. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">May 22, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 2,058 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/optimization-on-memory-usage-during-rust-cargo-code-compiling_601189">Optimization on Memory Usage During Rust Cargo Code Compiling</a> </h3> <p> This article provides a comprehensive guide on managing out-of-memory issues when compiling large projects with Rust's Cargo. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">May 21, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 3,055 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-orafce-to-support-oracle-compatibility_600837">Open Source PolarDB Uses Orafce to Support Oracle Compatibility</a> </h3> <p> This article describes how open source PolarDB uses orafce to support Oracle compatibility. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">February 5, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,984 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-pg-similarity-to-implement-17-types-of-text-similarity-search_600836">Open Source PolarDB Uses pg_similarity to Implement 17 Types of Text Similarity Search</a> </h3> <p> This article explains how the open-source version of PolarDB utilizes pg_similarity to implement 17 types of text similarity search. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">February 5, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,853 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-pg-rational-extension-to-support-stern-brocot-trees_600835">Open Source PolarDB Uses pg_rational Extension to Support Stern-Brocot Trees</a> </h3> <p> This article describes how open source PolarDB uses pg_rational extension to support Stern-Brocot trees to efficiently customize and adjust the order. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">February 5, 2024</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,800 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-rum-to-implement-efficient-searches-and-sorting_600623">Open Source PolarDB Uses Rum to Implement Efficient Searches and Sorting</a> </h3> <p> This article describes how open source PolarDB uses rum to implement efficient searches and sorting. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">December 6, 2023</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,435 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-postgresql-hll-to-accelerate-uv-sliding-analysis-and-real-time-recommendations_600622">Open Source PolarDB Uses postgresql_hll to Accelerate UV Sliding Analysis and Real-time Recommendations</a> </h3> <p> This article describes how open source PolarDB uses postgresql_hll to to achieve efficient UV (Unique Visitor) sliding analysis and real-time recommendation for filtered read lists. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">December 6, 2023</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,645 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-parray-gin-to-implement-efficient-fuzzy-searches-for-elements-in-arrays-and-json_600595">Open Source PolarDB Uses parray_gin to Implement Efficient Fuzzy Searches for Elements in Arrays and JSON</a> </h3> <p> This article focuses on how the open-source version of PolarDB utilizes parray_gin to implement efficient fuzzy searches for elements in arrays and JSON. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">November 28, 2023</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,605 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-duckdb-fdw-to-support-parquet-and-efficient-olap_600594">Open Source PolarDB Uses duckdb_fdw to Support Parquet and Efficient OLAP</a> </h3> <p> This article describes how open source PolarDB uses duckdb_fdw to support parquet, a columnar storage file format, and efficient OLAP. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">November 28, 2023</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,472 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-pg-trgm-gin-indexes-to-implement-efficient-fuzzy-queries_600492">Open Source PolarDB Uses pg_trgm GIN Indexes to Implement Efficient Fuzzy Queries</a> </h3> <p> This article describes how open source PolarDB uses pg_trgm GIN indexes to implement efficient fuzzy queries like '%xxx%'. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">October 18, 2023</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,653 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-enhances-time-series-data-with-timescaledb_600482">Open Source PolarDB Enhances Time Series Data with TimescaleDB</a> </h3> <p> This article describes how open source PolarDB uses TimescaleDB to implement high-speed writing, compression, real-time aggregation computing, and automatic aging of time series data. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">October 16, 2023</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,667 </span> </aside> </div> </main> </div> <div> <h2> <b>digoal</b> <span>Posted blog</span> </h2> <h4> <span></span> </h4> <main class="no-img"> <div class="items-left"> <h3> <a href="/blog/open-source-polardb-uses-pgpool-ii-to-implement-transparent-readwrite-splitting_600481">Open Source PolarDB Uses pgpool-II to Implement Transparent Read/Write Splitting</a> </h3> <p> This article describes how open source PolarDB uses pgpool-II to implement transparent read/write splitting. </p> <aside class="text-hidden"> <a href="/users/5840330778398571">digoal</a> <span> <img src="https://img.alicdn.com/tfs/TB1h1SxbkOWBuNjSsppXXXPgpXa-28-28.png" alt="" class="time">October 16, 2023</span> <span> <img src="https://img.alicdn.com/tfs/TB19L9AbXuWBuNjSspnXXX1NVXa-40-26.png" alt="" class="eye"> 1,873 </span> </aside> </div> </main> </div> </div> <div class="activities-main-left-clearn"> <button class="btn btn-default"> Learn More </button> </div> <div class="page activitiesPage"></div> </div> </div> <div class="activities-main-right col-md-4 col-sm-4"> <div class="activities-main-right-bar"> <div class="title"> Areas of Expertise </div> <div class="bar"> <a href="/tags/tagid_2159"> Database </a> </div> </div> <div class="activities-main-right-following"> <div class="title"> <p> Following <span>(0)</span> </p> <a href="javascript:;" id="FollowingAll">See All <i class="dbl-icon-base dbl-icon-base-arrow-right"></i> </a> </div> <div class="main row"> </div> </div> <div class="activities-main-right-followers"> <div class="title"> <p> Followers <span>(25)</span> </p> <a href="javascript:;" id="FollowersAll">See All <i class="dbl-icon-base dbl-icon-base-arrow-right"></i> </a> </div> <div class="main row"> <dl class="col-lg-3 col-sm-6 col-md-4"> <dt> <a href="/users/5647333717053560"><img src="https://yqfile.alicdn.com/avatar3.jpg" alt=""></a> </dt> <dd class="text-hidden"> <a href="/users/5647333717053560">fc0de</a> </dd> </dl> <dl class="col-lg-3 col-sm-6 col-md-4"> <dt> <a href="/users/5427999461102665"><img src="https://yqfile.alicdn.com/avatar3.jpg" alt=""></a> </dt> <dd class="text-hidden"> <a href="/users/5427999461102665">5427999461102665</a> </dd> </dl> <dl class="col-lg-3 col-sm-6 col-md-4"> <dt> <a href="/users/5148983336333541"><img src="https://yqfile.alicdn.com/avatar3.jpg" alt=""></a> </dt> <dd class="text-hidden"> <a href="/users/5148983336333541">KyleHuang</a> </dd> </dl> <dl class="col-lg-3 col-sm-6 col-md-4"> <dt> <a href="/users/5611950958141783"><img src="https://yqintl.alicdn.com/img_67225b90f418c09022cfe42f462a107c.png" alt=""></a> </dt> <dd class="text-hidden"> <a href="/users/5611950958141783">Farruh</a> </dd> </dl> <dl class="col-lg-3 col-sm-6 col-md-4"> <dt> <a href="/users/5054800944453502"><img src="https://yqfile.alicdn.com/avatar3.jpg" alt=""></a> </dt> <dd class="text-hidden"> <a href="/users/5054800944453502">5054800944453502</a> </dd> </dl> <dl class="col-lg-3 col-sm-6 col-md-4"> <dt> <a href="/users/5285325942704874"><img src="https://yqfile.alicdn.com/avatar3.jpg" alt=""></a> </dt> <dd class="text-hidden"> <a href="/users/5285325942704874">5285325942704874</a> </dd> </dl> <dl class="col-lg-3 col-sm-6 col-md-4"> <dt> <a href="/users/5387269818021960"><img src="https://community.alibabacloud.com/yqapi/follow/do?followType=user&id=5840330778398571" alt=""></a> </dt> <dd class="text-hidden"> <a href="/users/5387269818021960"><h1>12223</h1></a> </dd> </dl> <dl class="col-lg-3 col-sm-6 col-md-4"> <dt> <a href="/users/5555369271509962"><img src="https://yqfile.alicdn.com/avatar3.jpg" alt=""></a> </dt> <dd class="text-hidden"> <a href="/users/5555369271509962">5555369271509962</a> </dd> </dl> </div> </div> </div> </div> <div class="posts-main row"> <div class="col-md-8 col-sm-8"> <div class="posts-main-left"> <div class="posts-main-left-list"> </div> <div class="clearn"> <button class="btn btn-default"> Learn more </button> </div> <div class="page postsPage"></div> </div> </div> <div class="col-md-4 col-sm-4"> <div class="posts-main-right"> <div class="posts-main-right-top"> Latest Comments </div> <div class="posts-main-right-list"> </div> </div> </div> </div> <div class="series-main"> <div class="row"> <div class="main-item clearfix active"> <div class="list clearfix"> </div> <div class="page seriesPage"></div> </div> </div> </div> <div class="areas-main"></div> <div class="following-main"> <div class="following-main-top"></div> <div class="following-main-bottom"> <button class="btn btn-default" id="followingBtn">Show More</button> </div> </div> <div class="followers-main"> <div class="followers-main-top"></div> <div class="following-main-bottom"> <button class="btn btn-default" id="followersBtn">Show More</button> </div> </div> </div> </div> <div class="img-box following-dialog"></div> <div class="img-box followers-dialog"></div> <script type="text/javascript" nonce="0WYKEZQ9ZC"> window.localconfigs = { 'current': "activity", "activitiesApi": "/users/5840330778398571", "postsApi": "/users/5840330778398571/article", "followingApi": "/users/followList/5840330778398571", "followersApi": "/users/fansList/5840330778398571", "intrestFragmentApi": "/users/intrestFragment/5840330778398571", "followingFragmentApi": "/users/followFragment/5840330778398571", "followersFragmentApi": "/users/fansFragment/5840330778398571", "latestCommentsFragmentApi": "/users/latestCommentsFragment/5840330778398571", "nickname": "digoal" }; </script> <script type="text/javascript" nonce="0WYKEZQ9ZC"> window.configs = { "csrf-param": "yunqi_csrf", "csrf-token": "RACZ9RGCM1", "islogin": false, "registerurl": "https://account.alibabacloud.com/register/register.htm?from_type=yqclub&oauth_callback=https%3A%2F%2Fcommunity.alibabacloud.com%2Fusers%2F5840330778398571%3Fdo%3Dlogin", "loginurl": "https://account.alibabacloud.com/login/login.htm?from_type=yqclub&oauth_callback=https%3A%2F%2Fcommunity.alibabacloud.com%2Fusers%2F5840330778398571%3Fdo%3Dlogin", "isNeedNickname": false, "baseurl": "" }; </script> <script src="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/js/blogger.js"></script> <script src="//g.alicdn.com/aliyun-international/blog-assert/0.0.23/js/nav.js"></script> <script type="text/javascript" nonce="0WYKEZQ9ZC"> (function (i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function () { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m) })(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga'); ga('create', 'UA-86123020-1', 'auto'); ga('send', 'pageview'); </script> </body> </html>