postgresql▌

$22

Comprehensive PostgreSQL database engineering covering indexing, query optimization, replication, and production management. \n \n Covers 6 index types (B-tree, Hash, GiST, GIN, BRIN, SP-GiST) with decision matrices for choosing the right index for specific query patterns \n Includes streaming and logical replication setup, failover procedures, and high-availability configuration with synchronous/asynchronous modes \n Provides partitioning strategies (range, list, hash) with automation examples

PostgreSQL psql (PostgreSQL interactive terminal) is the primary command-line client for interacting with PostgreSQL databases. It provides both interactive query execution and powerful scripting capabilities for database management and administration.

Comprehensive assistance with postgresql development, generated from official documentation.

You are an expert in PostgreSQL with deep knowledge of advanced queries, indexing, performance tuning, replication, and database administration. You design and manage production PostgreSQL databases that are performant, reliable, and scalable.

Simple, pragmatic, opinionated. Only what matters for writing production-grade PostgreSQL queries.

Enable with ALTER TABLE tbl ENABLE ROW LEVEL SECURITY. Create policies: CREATE POLICY user_access ON orders FOR SELECT TO app_users USING (user_id = current_user_id()). Built-in user-based access control at the row level.

Schema design, query optimization, and operational best practices for PostgreSQL development. \n \n Covers schema design with native data types (UUID, JSONB, ARRAY, NUMERIC), primary/foreign keys, constraints, and table partitioning strategies for large datasets \n Indexing guidance including B-tree, GIN, GiST, and BRIN index types with examples for JSONB queries, partial indexes, and index maintenance via ANALYZE and monitoring \n Query optimization techniques using EXPLAIN ANALYZE, CTEs with m

Expert guidance on PostgreSQL-specific features, optimization patterns, and advanced data type capabilities. \n \n Covers JSONB operations, array types, window functions, full-text search, custom types, range types, and geometric types with practical examples \n Includes query optimization strategies using EXPLAIN ANALYZE, index design patterns (composite, partial, covering, expression), and connection/memory management \n Provides monitoring and maintenance techniques via pg_stat_statements, pg

PostgreSQL code review assistant covering JSONB, arrays, custom types, schema design, and security best practices. \n \n Reviews JSONB operations for indexing efficiency, array usage with GIN indexes, and proper containment operators \n Evaluates schema design including ENUM types, CITEXT for case-insensitive data, TIMESTAMPTZ usage, and CHECK constraints \n Identifies anti-patterns in function optimization, trigger design, and extension usage \n Assesses Row Level Security (RLS) implementation,