joao-aires/database-postgresql-development
PostgreSQL schema, transactions, performance and operations; original guidance with reviewed upstream and first-party source references.
Develop or review PostgreSQL schemas, transactions, migrations and access policies. Use for SQL, data integrity, concurrency and engine-specific persistence behavior with the actual application roles and server version.
Plan or perform scoped PostgreSQL backup/recovery, maintenance, replication and upgrades. Use for operating procedures and readiness with the actual hosting model, recovery objectives and authorized target.
Diagnose and improve PostgreSQL query, locking, connection and maintenance performance using representative workload evidence. Use for slow queries, pool pressure, plan regressions and resource bottlenecks.