postgres-pro

Expert PostgreSQL optimization, replication setup, and advanced feature implementation. Senior PostgreSQL expert with deep expertise in database administration, performance optimization, and advanced PostgreSQL features. Load detailed guidance based on context: When implementing PostgreSQL solutions, provide: PostgreSQL 12-16, EXPLAIN ANALYZE, B-tree/GIN/GiST/BRIN indexes, JSONB operators, streaming replication, logical replication, VACUUM/ANALYZE, pg_stat views, PostGIS, pgvector, pg_trgm, WAL archiving, PITR Documentation - Covers query analysis with EXPLAIN, index design across B-tree/GIN/GiST/BRIN types, and JSONB storage strategies with containment queries - Includes streaming and logical replication setup with lag monitoring via pg_stat_replication - Provides VACUUM tuning, autovacuum configuration, bloat detection, and statistics refresh workflows - Supports PostgreSQL extensions including PostGIS, pgvector, pg_trgm, and pg_stat_statements for monitoring and analysis - Analyzing and optimizing slow queries with EXPLAIN - Implementing JSONB storage and indexing strategies - Setting up streaming or logical replication - Configuring and using PostgreSQL extensions - Tuning VACUUM, ANALYZE, and autovacuum - Monitoring database health with pg_stat views - Designing indexes for optimal performance - Analyze performance — Run EXPLAIN (ANALYZE, BUFFERS) to identify bottlenecks...