PostgreSQL Evangelist. [My Git](https://github.com/digoal/blog/blob/master/README.md)
FollowThis article introduces two methods for executing SQL statements in batch: using the gexec convenient command in psql and using dynamic SQL.
The article introduces the factor contributing to the slow execution of the first SQL statement related to PostGIS library loading in PostgreSQL.
The article introduces the use of vector databases for similarity searches and deduplication.
This article introduces how to implement parallelism and concurrency control in the shell using GNU Parallel and a bash script.
This article introduces how to determine whether the current PostgreSQL database is in a consistent state.
This article focuses on how to use databases effectively, rather than how to manage database operations or develop database kernels.
This article discusses the process of online backup restoration and addresses three key questions regarding the recovery of database consistency.
This article describes the database optimization strategies and presents a demo illustrating how to boost database performance for queue processing tasks.
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.
This article provides a comprehensive guide on managing out-of-memory issues when compiling large projects with Rust's Cargo.
This article describes how open source PolarDB uses orafce to support Oracle compatibility.
This article explains how the open-source version of PolarDB utilizes pg_similarity to implement 17 types of text similarity search.
This article describes how open source PolarDB uses pg_rational extension to support Stern-Brocot trees to efficiently customize and adjust the order.
This article describes how open source PolarDB uses rum to implement efficient searches and sorting.
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.
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.
This article describes how open source PolarDB uses duckdb_fdw to support parquet, a columnar storage file format, and efficient OLAP.
This article describes how open source PolarDB uses pg_trgm GIN indexes to implement efficient fuzzy queries like '%xxx%'.
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.
This article describes how open source PolarDB uses pgpool-II to implement transparent read/write splitting.
Dikky Ryan Pratama Commented on PostgreSQL Convergence Filtering Optimization for Segment SQL with Multiple Range Conditions
5409482394982313 Commented on Applying PostgreSQL Graph Database to Social Scenarios
eJeeban Design Commented on Best Practices for PostgreSQL Time Series Database Design
5374541210554523 Commented on PostgreSQL: How to Optimize Spatial Index-based Query Performance for Multipolygon Data
profedsonbelem@gmail.com Commented on Create a Real-Time Data Exchange Platform with BottledWater-pg and Confluent
