×

digoal

13691 Reputation

PostgreSQL Evangelist. [My Git](https://github.com/digoal/blog/blob/master/README.md)

Follow
Activities(50) Posts(278) Series(11) Areas of Expertise Following Followers
Areas of Expertise

Following (0)

See All

Followers (24)

See All

Open Source PolarDB Uses Orafce to Support Oracle Compatibility

This article describes how open source PolarDB uses orafce to support Oracle compatibility.

Open Source PolarDB Uses pg_similarity to Implement 17 Types of Text Similarity Search

This article explains how the open-source version of PolarDB utilizes pg_similarity to implement 17 types of text similarity search.

Open Source PolarDB Uses pg_rational Extension to Support Stern-Brocot Trees

This article describes how open source PolarDB uses pg_rational extension to support Stern-Brocot trees to efficiently customize and adjust the order.

Open Source PolarDB Uses Rum to Implement Efficient Searches and Sorting

This article describes how open source PolarDB uses rum to implement efficient searches and sorting.

Open Source PolarDB Uses postgresql_hll to Accelerate UV Sliding Analysis and Real-time Recommendations

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.

Open Source PolarDB Uses parray_gin to Implement Efficient Fuzzy Searches for Elements in Arrays and JSON

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.

Open Source PolarDB Uses duckdb_fdw to Support Parquet and Efficient OLAP

This article describes how open source PolarDB uses duckdb_fdw to support parquet, a columnar storage file format, and efficient OLAP.

Open Source PolarDB Uses pg_trgm GIN Indexes to Implement Efficient Fuzzy Queries

This article describes how open source PolarDB uses pg_trgm GIN indexes to implement efficient fuzzy queries like '%xxx%'.

Open Source PolarDB Enhances Time Series Data with TimescaleDB

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.

Open Source PolarDB Uses pgpool-II to Implement Transparent Read/Write Splitting

This article describes how open source PolarDB uses pgpool-II to implement transparent read/write splitting.

Use Open Source PolarDB and imgsmlr for Efficient Image Storage and Similarity Search

This article provides guidance on using open-source PolarDB and imgsmlr for storing image feature values and performing quick image similarity searches.

Use Open Source PolarDB Bloom Filter Index to Filter Data

This article describes how to use PolarDB open-source bloom filter index to filter data based on any combination of fields.

Database Performance Optimization for High-concurrency Queue Processing Business

This article provides optimization methods and a demo for database performance optimization for queue processing business.

Use PGXN to Install the PostgreSQL | PolarDB Plug-in

This article describes how to use PostgreSQL Extension Network (PGXN) to Install the PostgreSQL | PolarDB Plug-in.

The Simple Deployment of PolarDB on Docker

This article introduces how to perform one-click deployment of PolarDB.

A Guide for Quick MacOS PolarDB-X Deployment

This article provides a guide on fast deployment of local PolarDB-X instances using PXD.

Using PostgreSQL Recursive SQL and the PL/pgSQL Function to Draw Fractal Graphs

This article explains how to use PostgreSQL Recursive SQL and the PL/pgSQL function to draw fractal graphs (with examples).

Configure a pgcat for the PolarDB Read/Write Splitting Connection Pool

This article explains how to configure a pgcat for the PolarDB Read/Write Splitting Connection Pool (with a deployment example).

Configure MADlib for PolarDB to Realize the Database Machine Learning Function

This article describes how to combine PolarDB with MADlib to provide PolarDB with a machine learning feature.

A Compatibility Evaluation Tool for Migrating SQL Server to PostgreSQL (Babelfish): Babelfish Compass

This article discusses the Babelfish Compass, including its background, evaluation guidelines, and tests.

Latest Comments

Dikky Ryan Pratama Commented on PostgreSQL Convergence Filtering Optimization for Segment SQL with Multiple Range Conditions

awesome!

5409482394982313 Commented on Applying PostgreSQL Graph Database to Social Scenarios

There are new clauses/keywords like cycle, is_cycle and using path introduced with recursive subquery in Postgres. Considering improvements done in Postgres, above article may require change as it was written in 2019.

eJeeban Design Commented on Best Practices for PostgreSQL Time Series Database Design

Nice Article

5374541210554523 Commented on PostgreSQL: How to Optimize Spatial Index-based Query Performance for Multipolygon Data

请问第一张图是怎么做出来的?GiST R树索引就一层树吗?

profedsonbelem@gmail.com Commented on Create a Real-Time Data Exchange Platform with BottledWater-pg and Confluent

parabéns pelo sey post.