×

digoal

9620 Reputation

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

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

Following (0)

See All

Followers (12)

See All

Modify Timezone through Alibaba Cloud RDS for PostgreSQL

This short article explains how to modify Timezone through Alibaba Cloud RDS for PostgreSQL.

Parameter Priority in PostgreSQL

This short article explains configurable portals and parameter priority in PostgreSQL.

Solution for the PostgreSQL Roaringbitmap UID Overflows Beyond Int4 (32 Bytes) – Offset

This short article explains formulas for the bitmap extension package of PostgreSQL.

PostgreSQL Dynamic Inline Code: Code Calls in Dynamic Stored Procedure – Client Stored Procedure Version Control

This article reviews PostgreSQL Dynamic Inline Code with examples.

PostgreSQL Business Function Code Version Control – Back Up Stored Procedures and Function Codes to Apache Subversion and GitHub Automatically

This article explains how to back up stored procedures and function codes to Apache Subversion and GitHub with examples.

Insert and Update Time of PostgreSQL Trace Record (Row and Tuple) – SPI Moddatetime Trigger

This article explains how to track the write time and last update time of the record with examples.

How to Prevent Downstream Timeline Errors Caused by Primary/Standby Switchover

In this article, the author explains how to prevent downstream timeline errors arising during primary/standby database switchover.

How to Avoid Timeline Errors during Database Switchover Based on Asynchronous Streaming Replication

In this article, the author explains how to maintain accurate databases by avoiding timeline errors while performing primary database switchover in a high-availability architecture.

PostgreSQL: How libpq Helps Configure Multi-Backend Connection Preferences

In this article, the author explains how libpq can support configuring multiple backend connection preferences, including read-only, prefer-read, and prefer-write.

Implicit Type Conversion of Any Types and Any Arrays on PostgreSQL

In this article, the author discusses the limitations of implicit type conversions in PostgreSQL and proposes some solutions based on any types.

How to View Shared Buffer Statistics Using pg_buffercache

In this article, the author explains how to use pg_buffercache to view various metrics of a shared buffer in PostgreSQL.

How to Build a Time-series Database for Prometheus Using pg_prometheus

In this article, the author explains how to use PostgreSQL as a backend database system for Prometheus using the pg_prometheus plugin developed by TimescaleDB.

How to Use pg_receivewal with Synchronous Replication to Mirror Redo Logs

In this article, the author explains how to mirror redo logs in PostgreSQL using pg_receivewal with synchronous replication.

How to Set Up libpq Failover and Load Balancing for JDBC Driver Layer

In this article, the author discusses libpq failover and load balancing JDBC driver layer in PostgreSQL.

How to Write into a Database Using reWriteBatchedInserts Parameter

In this article, the author explains how to perform batch insert in PostgreSQL to write data into a database quickly.

How to Use PostgreSQL log_fdw to Query Logs

In this article, the author explains how to use PostgreSQL log_fdw to query log data directly in ApsaraDB RDS for PostgreSQL.

PostgreSQL v12: How pg_stat_statements Causes High-concurrency Performance Issues

In this article, the author discusses how enabling PostgreSQL pg_stat_statements in PG v12 causes high-concurrency performance issues.

PostgreSQL: How ORG GIS FDW External Table Supports Pushdown

In this article, the author demonstrates the support for external table pushdown in PostgreSQL and explains how multiple data sources are supported.

Alibaba Cloud: How to Use FIO to Test the IO Performance of ECS Local SSD and ESSD (Part 2)

In this article, the author explains testing the IO performance of Local SSD and ESSD storage types of ECS in Alibaba Cloud using FIO.

How to Use FIO to Test the IO Performance of ECS Local SSD and ESSD (Part 1)

In this article, the author explains testing the IO performance of Local SSD and ESSD storage types of ECS in Alibaba Cloud using FIO.

Latest Comments

5295094317782498 Commented on PostgreSQL Time-Series Best Practices: Stock Exchange System Database

Thanks for the great article!What postgres configuration was used and on what hardware did it run?

5244987673819126 Commented on Using the Built-In and Custom Ranking Algorithms of PostgreSQL for Full-Text Searches

Hello, I am trying to solve the issue when I need more weight levels than just 4 and I found your article. Unfortunately I am not that experienced in the SQL, could you please explain a little bit more the first method with ts_vector? I mean I do not understand how to put everything together. Let's say I have tsquery which I want to rank. I call the cat_ranking(tsquery), where did you get the 'contains_element' please?

5868769402049331 Commented on Optimizations with Full-Text Search in PostgreSQL

Talking about PostgreSQL performance issues, I would like to add one more possible solution for locating bottlenecks and tunning the performance of slow queries - the visual PostgreSQL query analyzer can help you in solving all the mentioned issues https://www.devart.com/dbforge/postgresql/studio/

Raja_KT Commented on Optimizing Time Series Querying on Alibaba Cloud RDS for PostgreSQL

Good one. But this is specific to these specific scenarios. Will it be the same for RDS MySQL, MSSQL.....?