Optimize PostgreSQL databases with indexing, partitioning, and query tuning.
npx skills add https://github.com/mefardales/skillbox --skill postgresql-mefardales
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/mefardales/skillbox/tree/main/skills/data/postgresql Command: npx skills add https://github.com/mefardales/skillbox --skill postgresql-mefardales
This Skill provides advanced strategies and patterns for building, optimizing, and managing PostgreSQL databases in production environments, moving beyond basic schema design.
EXPLAIN ANALYZE, CTEs, and window functions.tsvector, tsquery, and pg_trgm for efficient text searching.pg_dump, pg_basebackup, and WAL archiving.pg_trgm, pg_stat_statements, and postgis.Use the postgresql skill to create an index on the 'created_at' column of the 'orders' table.
High-intent search queries and answers about installing and using this skill.
Optimize slow PostgreSQL queries by analyzing execution plans with EXPLAIN ANALYZE, leveraging CTEs and window functions, and applying B-tree, GIN, or GiST indexing strategies to improve data retrieval performance.
Scale large PostgreSQL tables by implementing range and list partitioning, which divides massive datasets into smaller, manageable chunks to maintain query performance and simplify data management.
Full-text search in PostgreSQL works by leveraging tsvector and tsquery data types alongside GIN indexes and pg_trgm extension to perform efficient and rapid text searching across stored documents.
Enforce multi-tenant data isolation directly in PostgreSQL by implementing row-level security policies, ensuring tenants only access their authorized rows without complex application-level filtering logic.
Use partial indexes to optimize queries targeting specific subsets of data, reducing index size and maintenance overhead, and expression indexes to pre-compute results for queries filtering on computed values.
Recommended PostgreSQL backup strategies for production include using pg_dump for logical backups, pg_basebackup for physical backups, and continuous WAL archiving for point-in-time recovery.
ROYCE-8425Optimize PostgreSQL database performance, schema design, indexing, and security.
vertivolatamAutomate PostgreSQL replication, failover, backups, pooling, and monitoring.
HieubkavAnalyze database indexes and query execution plans to recommend optimizations.
rnavarychCompare 12 NewSQL and distributed SQL databases for consistency and sharding.