II.
SkillArea overview
Reference · liveskill-area:postgres-tuning
Postgres Performance Tuning overview
PostgreSQL performance work: reading EXPLAIN (ANALYZE, BUFFERS) plans, btree / GIN / GiST / BRIN index selection, partial and expression indexes, table partitioning, vacuum/autovacuum, statistics targets, work_mem and shared_buffers tuning, and query rewriting.
Attributes
displayName
Postgres Performance Tuning
description
PostgreSQL performance work: reading EXPLAIN (ANALYZE, BUFFERS) plans,
btree / GIN / GiST / BRIN index selection, partial and expression
indexes, table partitioning, vacuum/autovacuum, statistics targets,
work_mem and shared_buffers tuning, and query rewriting.
domains
requiresStackParts
expertiseLevels
- intermediate
- expert
- authoritative
Outgoing edges
applies_to3
- domain:data-engineering·DomainData Engineering
- domain:databases·DomainDatabases
- specialization:postgres-tuning·SpecializationPostgreSQL Performance Tuning
uses_stack_part1
- stack-part:relational-database·StackPartRelational Database
Incoming edges
addresses1
- skill:python-django-debug·SkillPython Django Debug
lib_requires_skill_area1
- lib-skill:software-architecture--db-query-analyzer·LibrarySkilldb-query-analyzer
prerequisite_for_learning3
- skill-area:query-optimizer-internals·SkillAreaQuery Optimizer Internals
- skill-area:connection-pool-tuning·SkillAreaConnection Pool Tuning
- skill-area:backend-data-persistence·SkillAreaBackend Data Persistence
requires_expertise4
- role:database-administrator·RoleDatabase Administrator
- role:data-analyst·RoleData Analyst
- role:backend-engineer·RoleBackend Engineer
- role:database-engineer·RoleDatabase Engineer
requires_skill_area21
- skill-area:database-migrations-zero-downtime·SkillAreaZero-Downtime Database Migrations
- stack-profile:geospatial-analytics·StackProfileGeospatial Analytics (PostGIS + Python + Leaflet/Mapbox + GeoPandas)
- stack-profile:go-gin-postgres·StackProfileGo + Gin + Postgres
- stack-profile:go-grpc-postgres·StackProfileGo + gRPC + PostgreSQL
- workflow:backend-performance-profiling·WorkflowBackend Performance Profiling
- workflow:database-migration-cutover·WorkflowDatabase Migration Cutover
- workflow:data-retention-review·WorkflowData Retention Review
- workflow:ad-hoc-analysis-request-cycle·WorkflowAd-Hoc Analysis Request Cycle
- workflow:data-catalog-maintenance·WorkflowData Catalog Maintenance
- workflow:dbt-model-review·Workflowdbt Model Review
- workflow:data-governance-review·WorkflowData Governance Review
- workflow:schema-migration·WorkflowSchema Migration
- workflow:query-performance-review·WorkflowQuery Performance Review
- workflow:backup-recovery-drill·WorkflowBackup Recovery Drill
- workflow:database-index-optimization·WorkflowDatabase Index Optimization
- workflow:database-failover-drill·WorkflowDatabase Failover Drill
- workflow:database-connection-pool-tuning·WorkflowDatabase Connection Pool Tuning
- workflow:data-governance-review·WorkflowData Governance Review
- workflow:schema-migration·WorkflowSchema Migration
- workflow:query-performance-review·WorkflowQuery Performance Review
- workflow:backup-recovery-drill·WorkflowBackup Recovery Drill
stack_part_used_by1
- stack-part:relational-database·StackPartRelational Database