Apply PostgreSQL patterns for query optimization, concurrency control, and safe migrations.
npx skills add https://github.com/zzoohub/mealio --skill postgresql-zzoohub
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/zzoohub/mealio/tree/main/.claude/skills/postgresql Command: npx skills add https://github.com/zzoohub/mealio --skill postgresql-zzoohub
PostgreSQL problem-solving patterns for production systems. This section describes how to identify performance bottlenecks, concurrency issues, and migration challenges in real-world PostgreSQL deployments, and how to apply proven patterns to address them.
Identify a slow-producing query in your production workload and implement a cursor-based pagination or an indexing strategy described above to observe measurable improvements.
High-intent search queries and answers about installing and using this skill.
Cursor-based pagination in PostgreSQL avoids slow OFFSET scans by paging on the (created_at, id) tuple with a stable sort order. This pattern fetches subsequent pages efficiently without re-scanning skipped rows in large datasets.
Zero-downtime PostgreSQL migrations use strategies like adding constraints using NOT VALID then applying VALIDATE concurrently, alongside batched data backfills. This prevents table locks and maintains production reliability during schema changes.
Use BRIN indexes for large tables with natural ordering, GIN indexes to accelerate complex queries like full-text search, and expression indexes to optimize queries filtering by computed values, targeting specific query bottleneck patterns.
High-concurrency PostgreSQL updates require strategies like utilizing SKIP LOCKED for queue processing and batching transactions. These approaches reduce row contention and improve throughput under heavy concurrent workloads.
Yes, the approach applies to time-series data modeling in PostgreSQL by providing specific patterns for table partitioning and efficient data organization at scale to manage large datasets and high-traffic workloads effectively.
rongaredeApply PostgreSQL patterns for query tuning, indexing, and Row Level Security.
jralphDesign relational schemas with normalization, indexing, and migration strategies.
SamuelSahaOptimize PostgreSQL databases with query tuning, indexing, and replication strategies.
ariesanhthuOptimize PostgreSQL queries, indexing, JSONB, partitioning, and replication.
