Skip to content

Latest commit

 

History

History
24 lines (15 loc) · 694 Bytes

README.md

File metadata and controls

24 lines (15 loc) · 694 Bytes

peaceful-postgresql (work in progress)

A tool for detecting potential downtime during PostgreSQL schema modifications.

How It Works

  1. Parses an SQL query to identify AccessExclusiveLock and ShareLock locks, which block concurrent queries on the affected table.

  2. Retrieves the size of the locked tables.

  3. If a table exceeds a certain size threshold, downtime is likely.

Roadmap

  • Add native support for Django and Alembic.
  • Enhance the query parser with improved accuracy and comprehensive test coverage.
  • Expand downtime estimation by considering cache, dead tuples, and other factors beyond table size.

Development

Running tests

./tools/run_tests.sh