Optimize complex PostgreSQL databases for speed and efficiency.
PostgreSQL Advanced Expert
PostgreSQL, Performance Tuning, Extensions
Best for
- ▸Optimizing slow PostgreSQL queries with EXPLAIN ANALYZE and index strategy
- ▸Implementing pgvector for AI embedding search with HNSW indexes
- ▸Setting up PostGIS spatial queries with R-tree optimization
- ▸Configuring TimescaleDB partitioning for high-volume time series data
What you'll get
- ▸EXPLAIN ANALYZE breakdown with specific index recommendations and rewritten queries with performance projections
- ▸Step-by-step pgvector installation with HNSW index configuration and similarity search implementation code
- ▸Production PostgreSQL tuning checklist with specific postgresql.conf parameters and monitoring queries
Production PostgreSQL performance issues, query execution plans, schema designs, or extension implementation requirements with specific workload characteristics.
Detailed optimization recommendations with specific PostgreSQL configuration changes, index strategies, query rewrites, and extension setup commands.
What's inside
“You are a PostgreSQL Advanced Expert. You master PostgreSQL internals, performance optimization, and extensions like pgvector, PostGIS, and TimescaleDB. - Analyze workloads through PostgreSQL's cost model: query planner behavior, MVCC tuple visibility, WAL mechanics, and vacuum system, not just SQL ...”
Covers
Not designed for ↓
- ×Basic SQL syntax teaching or simple SELECT/INSERT queries
- ×MySQL, SQL Server, or other database systems
- ×Application-level database connection pooling configuration
- ×Cloud database service management (RDS/Cloud SQL admin tasks)
SupaScore
89.1▼
Evidence Policy
Standard: no explicit evidence policy.
Research Foundation: 7 sources (4 official docs, 2 books, 1 web)
This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.
Version History
v5.5 final distill
Pipeline v4: rebuilt with 3 helper skills
Initial version
Works well with
Need more depth?
Specialist skills that go deeper in areas this skill touches.
Common Workflows
Database Performance Optimization Pipeline
End-to-end PostgreSQL performance optimization from query tuning to production monitoring setup
© 2026 Kill The Dragon GmbH. This skill and its system prompt are protected by copyright. Unauthorised redistribution is prohibited. Terms of Service · Legal Notice