Partition Table

An Improvement of Aggregate Query Parallelism for a Large Number of Partitions in a PostgreSQL Partition Table

This article discusses PostgreSQL 12 and the aggregation operation.

PostgreSQL pg_pathman: Partition Tables into Native Partition Tables

In this article, the author explains how to partition tables into native partition tables using PostgreSQL pg_pathman.

PostgreSQL Feed Systems Similar to Weibo - Design and Performance Metrics

This article describes scenarios that are related message pushing and message consumption by using a 2048-letter-long message as an example.