postgres-patterns

To optimize PostgreSQL query performance, use composite indexes for multi-column filters and partial indexes when queries target a specific subset of rows. This Skill provides index cheat sheets and patterns to select the right strategy for common queries.

The best way to implement Row Level Security (RLS) in PostgreSQL is by defining policies that restrict data access based on user roles. This Skill provides RLS policy patterns based on Supabase best practices to secure your database tables effectively.

You need a covering index in PostgreSQL when your queries select specific columns that can be entirely satisfied by the index without accessing the main table. This Skill covers covering indexes and other SQL patterns to eliminate slow queries and table bloat.

Yes, this PostgreSQL optimization guide includes common SQL patterns such as UPSERT for data insertion and cursor pagination for efficient large dataset retrieval. It also covers queue processing and anti-pattern detection for unindexed foreign keys.

To prevent table bloat and manage resources, configure PostgreSQL connection limits and timeouts using the configuration template provided by this Skill. It also includes monitoring extensions to detect slow queries and anti-patterns early.