Tagged articles

8 articles

Page 1 of 1

Jan 31, 2026 · Databases

7 Overlooked PostgreSQL Architecture Mistakes That Kill Performance

The article reveals seven common PostgreSQL architectural oversights—such as neglecting vacuum, misusing UUID primary keys, treating the database as a queue, missing indexes, over‑relying on ORMs, ignoring write‑side scaling, and failing to partition large tables—that silently degrade performance and reliability, and provides concrete fixes and best‑practice configurations.

ORMPartitioningPostgreSQL

0 likes · 7 min read

7 Overlooked PostgreSQL Architecture Mistakes That Kill Performance

dbaplus Community

Aug 14, 2025 · Databases

10 Common Reasons Your PostgreSQL Queries Are Slow—and How to Fix Them

Discover the ten most frequent causes of sluggish PostgreSQL queries—from missing or inefficient indexes and poor query design to lack of vacuuming, table bloat, wrong data types, excessive sequential scans, deadlocks, missing connection pooling, overused ORDER BY/DISTINCT, and misconfigured settings—and learn concrete steps to resolve each issue.

PostgreSQLVacuumindexes

0 likes · 6 min read

10 Common Reasons Your PostgreSQL Queries Are Slow—and How to Fix Them

ITPUB

Apr 22, 2023 · Databases

Why PostgreSQL Vacuums Can’t Reclaim Space After Deletes and Updates

The article examines why PostgreSQL tables often retain large disk footprints after massive inserts, updates, and deletions, showing experiments on PG 13/PG 14, analyzing factors such as long‑running transactions, replication slots, uncommitted transactions, fillfactor settings, and the old_snapshot_threshold bug, and offering practical diagnostics and mitigation steps.

PostgreSQLVacuumfillfactor

0 likes · 8 min read

Why PostgreSQL Vacuums Can’t Reclaim Space After Deletes and Updates

dbaplus Community

Nov 18, 2022 · Databases

Why openGauss Misses Index‑Only Scan and How USTORE Fixes It

The article examines why openGauss 2.0/3.0 cannot use Index‑Only Scan for covering indexes, explores the role of the visibility map and VACUUM, compares behavior with PostgreSQL 11, and shows how the USTORE storage engine can finally enable true covering indexes.

Index Only ScanUSTOREVacuum

0 likes · 11 min read

Why openGauss Misses Index‑Only Scan and How USTORE Fixes It

Qunar Tech Salon

Mar 30, 2022 · Databases

Understanding and Optimizing PostgreSQL VACUUM and AUTOVACUUM

This article explains the purpose and mechanics of PostgreSQL's VACUUM and AUTOVACUUM processes, demonstrates practical examples of table bloat, transaction ID handling, and provides step‑by‑step guidance for precise triggering and performance optimization of vacuum operations.

AUTOVACUUMDatabase TuningSQL

0 likes · 37 min read

Understanding and Optimizing PostgreSQL VACUUM and AUTOVACUUM

ITPUB

Mar 24, 2022 · Databases

How to Prevent PostgreSQL XID Wraparound and Fix Freeze Errors

This article explains the cause of PostgreSQL "database is not accepting commands to avoid wraparound data loss" errors, details the XID allocation and wraparound mechanisms, and provides manual and automated vacuum‑freeze solutions with concrete SQL commands and scripts.

Database MaintenanceFreezePostgreSQL

0 likes · 14 min read

How to Prevent PostgreSQL XID Wraparound and Fix Freeze Errors

Alibaba Cloud Developer

Jan 12, 2022 · Databases

How to Slash Cloud Data Warehouse Costs with ADB PG Disk Optimization

This article explains how enterprises can dramatically reduce cloud‑native data‑warehouse expenses by understanding ADB PG/Greenplum architecture, applying disk‑reservation and lock‑write safeguards, and implementing practical optimizations such as table compression, hot‑cold tiering, vacuuming, redundant‑index cleanup, replication conversion, and isolated temporary‑table spaces.

ADB PGCost reductionData Warehouse

0 likes · 25 min read

How to Slash Cloud Data Warehouse Costs with ADB PG Disk Optimization

21CTO

Aug 18, 2015 · Databases

Understanding PostgreSQL MVCC: How It Handles Concurrency

PostgreSQL uses Multi-Version Concurrency Control (MVCC) to ensure reads never block writes and vice versa, assigning transaction IDs to rows, managing visibility with xmin/xmax, supporting isolation levels, and requiring periodic VACUUM to clean dead rows and handle XID wraparound.

MVCCPostgreSQLVacuum

0 likes · 7 min read

Understanding PostgreSQL MVCC: How It Handles Concurrency