ApsaraDB RDS for PostgreSQL 12: Improved High Concurrency Performance for Large Partitioned Tables

This article enlists some features of ApsaraDB RDS for PostgreSQL 12, focusing on the high-concurrency performance for large partitioned tables.

How Can We Combine PostgreSQL and MySQL to Make the Whole Greater than the Sum of the Parts? (Part 2)

In this blog series, we'll show you how to combine both ApsaraDB RDS for PostgreSQL and MySQL to enhance business value.

How Can We Combine PostgreSQL and MySQL to Make the Whole Greater than the Sum of the Parts? (Part 1)

In this blog series, we'll show you how to combine both ApsaraDB RDS for PostgreSQL and MySQL to enhance business value.

First Experience with PostgreSQL 13 Beta 1

The PostgreSQL Global Development Group released the first beta of PostgreSQL 13 on May 21, 2020. Zhuodao takes a look at all the new features and changes.

Who Comes Next After the Rise of Data Warehouses and Data Lakes?

In this blog, two experts from Alibaba Cloud talk about the advantages that data warehouses and data lakes bring to handle large, complex architecture for businesses.

Provisioning IoT Clusters with ApsaraDB for PostgreSQL

This article focuses on how ApsaraDB for PostgreSQL meets the requirements of IoT applications while maintaining the needs of varying data structures and datasets.

Use Case Analysis - Image Recognition and Similar Feature Retrieval with PostgreSQL

This article discusses the challenges in image recognition and demonstrates how ApsaraDB RDS for PostgreSQL solves these challenges.

Use Case Analysis - Real-time Precision Marketing and Group Selection

This article discusses various pain points and technical solutions for precision marketing and group selection across multiple industries.

5 Simple Steps to Migrate Data Warehouses from Redshift to Alibaba Cloud AnalyticDB for PG

This article describes how to migrate data between the two data warehouse platforms (from Redshift to Alibaba Cloud AnalyticDB for PG) in just five simple steps.

Reducing the Cost of Enterprise Database IT amid the Coronavirus Outbreak

In this blog, we'll show you how you can save on your database expenses with ApsaraDB RDS for PostgreSQL to cope with the recent COVID-19 outbreak.

Real-Time Conversion in Data Loading - Triggers and Rules

This article explains how PostgreSQL supports triggers and rules to effectively convert string data into the types supported by PostgreSQL in real-time.

How to Optimize Duplicate Data Cleansing in PostgreSQL

This article evaluates different duplicate data cleansing techniques while considering several technical database issues in PostgreSQL.

How to Retrieve and Deduplicate Similar Text in PostgreSQL

This article attempts to answer a series of questions raised in the Alibaba Cloud Community's Q&A section regarding the retrieval and deduplication of similar text in PostgreSQL.

PostgreSQL Data Deduplication Methods

This article describes the different PostgreSQL methods to remove duplicates and suggests how to choose the method that works best for users.

PostgreSQL Data Rotate Method Introduction: Overwrite History Data by Time

This article explains the method to rotate data using partition tables in polling mode while using truncate to clear partitions.

How Does PostgreSQL Implement Batch Update, Deletion, and Insertion?

This article addresses all the frequently asked questions pertaining to batch update, insertion, and deletion in PostgreSQL.

How Does PostgreSQL Implement Upsert to Automatically Separate New Data from Old Data

This article explains the method that PostgreSQL uses to implement upsert for automatically separating new data from old data.

Data Sampling in PostgreSQL

This article gives a quick walkthrough on how to perform data sampling in PostgreSQL using a comprehensive example.

Use of the PostgreSQL Upsert (INSERT ON CONFLICT DO) Function

This article introduces a new function of PostgreSQL 9.5 called Upsert (INSERT ON CONFLICT DO).

Automatic Cleaning and Scheduling of PostgreSQL Rotate Tables - Constraints and Triggers

This article demonstrates how to use constraints and triggers for automatic cleaning and scheduling of PostgreSQL tables.