Skip to content
ITNotes ITNotes

From Terminal to Cloud

  • AI
  • DevOps
  • HomeLab
  • Linux
  • Networking
  • Programming
  • English
    • English
    • Tiếng Việt
    • 日本語
  • AI
  • DevOps
  • HomeLab
  • Linux
  • Networking
  • Programming
  • English
    • English
    • Tiếng Việt
    • 日本語
Home » MVCC
Database tutorial - IT technology blog
Posted inDatabase

Using pg_repack to Fix Table and Index Bloat in PostgreSQL Without Locking Tables

October 8, 2026
PostgreSQL's MVCC model creates dead tuples over time, causing table and index bloat that slows queries and wastes disk space. This guide covers how to use pg_repack to reclaim that space in production with zero table locks — including installation, usage patterns, and ongoing monitoring.
Read More
Database tutorial - IT technology blog
Posted inDatabase

Scaling Beyond Locks: A Practical Guide to MVCC in PostgreSQL and MySQL

September 8, 2026
MVCC is why your database doesn't crawl to a halt during high traffic. Learn the differences between PostgreSQL and MySQL's approach and how to avoid common concurrency traps.
Read More
Copyright 2026 — ITNotes. All rights reserved.
Privacy Policy | Terms of Service | Contact: [email protected] DMCA.com Protection Status
Scroll to Top