postgres-patterns

To optimize slow PostgreSQL queries, you select the correct index type based on your query pattern, such as using GIN for JSONB filtering. This reference provides an index cheat sheet derived from Supabase guidelines to match index types to common query patterns.

Common PostgreSQL anti-patterns include inefficient data type choices and poor indexing strategies that lead to table bloat and slow queries. This reference helps detect these pitfalls and provides schema design recommendations to ensure efficient storage and querying.

You implement cursor pagination and UPSERT patterns in PostgreSQL by following established SQL best practices to handle data updates and large dataset traversal efficiently. This guide covers these common SQL patterns alongside queueing and Row Level Security guidelines.

The best PostgreSQL data types for efficient storage and querying are those that precisely match your data's domain and access patterns. This reference provides data type recommendations to help you choose the most appropriate columns when designing new tables.

Yes, there are basic configuration templates for essential PostgreSQL system settings to help you establish a performance baseline. This Skill provides starting points for system configuration derived from Supabase best practices.