Database Performance

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 to Create Multiple Indexes for a Field?

In this article, we'll discuss how to create multiple indexes for the same column in a PostgreSQL database table to solve performance issues and overcome various constraints.

PostgreSQL v12 Performance: Alibaba Cloud ECS Local SSD vs. ESSD PL3

In this article, the author discusses and demonstrates the performance of PostgreSQL v12 with respect to local and cloud SSD storage types in Alibaba Cloud.