Tag: database-tuning
PostgreSQL Vacuum Monitoring and Tuning
Monitor and tune PostgreSQL vacuum operations, including autovacuum configuration, progress tracking, and transaction ID wraparound prevention. It provides specific tuning recommendations for high-churn OLTP and large analytical tables.
PostgreSQL Query Optimization and Rewrite Patterns
This skill provides a structured workflow for analysing PostgreSQL execution plans and applying restructuring patterns to improve query performance. It covers techniques such as converting subqueries to joins, managing CTE materialisation, …
PostgreSQL Lock Contention Diagnosis
This skill provides a structured workflow for diagnosing PostgreSQL lock contention, including identifying blocking chains, analysing wait events, and resolving deadlocks. It guides the agent through investigating idle-in-transaction sessio…
PostgreSQL I/O Performance Deep-Dive
A structured workflow for investigating PostgreSQL I/O performance, covering buffer pool efficiency, table and index hotspots, and checkpoint performance. It correlates I/O patterns with query workloads to diagnose disk bottlenecks and conf…
PostgreSQL Configuration Tuning and Optimization
Provides systematic PostgreSQL configuration tuning by analysing hardware profiles, workload types, and current settings to generate hardware-aware ALTER SYSTEM recommendations.
Convex Application Performance Audit
Diagnoses and resolves performance bottlenecks in Convex applications, including read amplification, write contention, and subscription costs. It provides a structured workflow for auditing function paths and implementing optimizations such…
Convex Application Performance Audit
This skill diagnoses and optimises performance issues in Convex applications, including read amplification, write contention, and subscription costs. It provides a structured workflow for tracing read/write sets and applying targeted fixes …