8314 Reputation

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

Activities(50) Posts(173) Series(10) Areas of Expertise Following Followers
Areas of Expertise

Following (0)

See All

Followers (10)

See All

PostgreSQL Deferrable Constraints: Unique, Primary Key, Foreign Key, and Exclude

In this article, the author explains various deferrable constraints in PostgreSQL, including unique, primary key, foreign key, and exclude.

How to Mask Sensitive Information on PostgreSQL Using Anon Plug-in

In this article, the author explains how to mask sensitive information such as email addresses and credit card numbers in PostgreSQL using the Anon plug-in.

How to Switch a Secondary Physical Database to a Secondary Logical Database on PostgreSQL

In this article, the author explains switching a secondary physical database to a secondary logical database based on PostgreSQL.

PostgreSQL Chemical Analysis Module: RDKit Cartridge 1 for Environment Deployment

In this article, we introduce the RDKit toolset for managing and analyzing large sets of chemical data and explain how PostgreSQL acts as the molecular database in this toolset.

ApsaraDB RDS for PostgreSQL: postgres_fdw Sharding for Database and Table Sharding (Not DRDS)

In this article, the author explains database and table sharding using PostgreSQL postgres_fdw module.

How to Build a Remote Secondary Database on PostgreSQL Using pg_basebackup

In this article, the author explains how to run a self-built standby remote secondary database of ApsaraDB RDS for PostgreSQL 11 using PostgreSQL pg_basebackup.

Small-scale Real-time Data Warehouse: How ApsaraDB RDS for PostgreSQL Supports mysql_fdw

This article explains creating a small-scale real-time data warehouse with ApsaraDB RDS for PostgreSQL and describes how it supports mysql_fdw to enable read and write access to MySQL.

How to Enable dblink and postgres_fdw Permissions in ApsaraDB RDS for PostgreSQL 11

In this article, the author explains dblink and postgres_fdw permissions in ApsaraDb RDS for PostgreSQL 11.

PostgreSQL: Multi-node (Quorum-based), Zero Data Loss, and HA (Failover, Switchover) Solution

In this article, we discuss the implementation of a quorum-based PostgreSQL cluster with multiple nodes with zero data loss and high availability architecture.

PostgreSQL: Financial Accounting Data Snapshot Analysis Use Cases

In this article, we discuss how you can store and analyze financial data using PostgreSQL and why integrating RDS for PostgreSQL with OSS is beneficial.

PostgreSQL: How to Predict Stock Price Using Univariate Linear Regression

In this article, we will show you how to use PostgreSQL to predict stock price by employing univariate linear regression.

PostgreSQL: Stock Price Prediction Using Multiple Linear Regression Analysis

In this article, we will explore multiple linear regression analysis and use it to describe stock price prediction in PostgreSQL.

PostgreSQL: High Availability and Disaster Recovery Solutions for the Financial Industry

In this article, the author discusses how PostgreSQL helps achieve various requirements in the financial sector, including high availability and disaster recovery.

PostgreSQL: Performing Linear Regression Analysis to Predict Future Data (Part 2)

In this article, the author discusses a practical example to demonstrate future data prediction using linear regression analysis in PostgreSQL.

PostgreSQL: Performing Linear Regression Analysis to Predict Future Data (Part 1)

In this article, the author explores linear regression analysis and describes how it helps predict future data using PostgreSQL.

PostgreSQL: Zero Data Loss and High-Performance Synchronous Switching and Transaction-Level Asynchronization

In this article, the author explains synchronous switching and transaction-level asynchronization in PostgreSQL with zero data loss and high performance.

PostgreSQL: Risk Control Assistant for Small Loans and Angel Investment Based on Graph Search and Mapping Analysis

This article discusses the design of a PostgreSQL business database to assess the risks involved in small loans and angel investments using graph search and mapping analysis.

Uninterrupted Database Switchover Using Session Resource Migration

This article discusses performing an uninterrupted database switchover without impacting user experience using session resource migration.

How PostgreSQL Is Compatible with SQL Server

In this article, the author explains three different methods to demonstrate the compatibility of PostgreSQL with SQL server.

How PostgreSQL Queries Tables Depending on Extension (Type)

In this article, the author discusses PostgreSQL queries based on the extension types.

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.....?