postgresql-optimization

提供 PostgreSQL 的性能优化、类型与扩展使用建议。

针对 PostgreSQL 的特性和性能问题给出实操建议，涵盖 JSONB 查询、数组与自定义类型、range/几何类型、全文检索、window 函数和扩展生态。在写查询、设计表结构或做性能调优时用，能把数据库独有功能用得更高效。提供具体 SQL 模式和调优思路，不只是泛泛而谈。

# PostgreSQL Development Assistant

Expert PostgreSQL guidance for ${selection} (or entire project if no selection). Focus on PostgreSQL-specific features, optimization patterns, and advanced capabilities.

## � PostgreSQL-Specific Features

### JSONB Operations
```sql
-- Advanced JSONB queries
CREATE TABLE events (
    id SERIAL PRIMARY KEY,
    data JSONB NOT NULL,
    created_at TIMESTAMPTZ DEFAULT NOW()
);

-- GIN index for JSONB performance
CREATE INDEX idx_events_data_gin ON events USING gin(data);

-- JSONB containment and path queries
SELECT * FROM events 
WHERE data @> '{"type": "login"}'
  AND data #>> '{user,role}' = 'admin';

-- JSONB aggregation
SELECT jsonb_agg(data) FROM event