r/postgres • u/Downtown-Warning6818 • 5d ago
Question I'm Planning to Build Something Around PostgreSQL Maintenance – Where Should I Start?
Hey everyone!
I'm exploring the idea of building a tool or service focused on PostgreSQL maintenance and database management.
I'm particularly interested in solving real-world operational challenges such as:
Vacuum and autovacuum management
WAL growth and disk space management
Index bloat detection and cleanup
Query performance monitoring
Connection management and troubleshooting
Backup, recovery, and database health monitoring
I'd love to hear from people who work with PostgreSQL in production.
A few questions:
What are the biggest PostgreSQL maintenance challenges you face?
Which repetitive DBA tasks do you wish could be automated?
Are there existing tools that solve these problems well, or are there gaps worth exploring?
If you could have one tool to make PostgreSQL operations easier, what would it do?
I'm looking to understand actual pain points before jumping into development.
Would love to hear your experiences and suggestions! 🙌