Cases

• Full-Text Search — tsvector ranking, trigram fuzzy match, autocomplete
• JSONB Atribut Dinamis — filter atribut dinamis via containment (@>), facet count, generated column
• Partisi & EXPLAIN Playground — orders dipartisi per bulan, BRIN vs BTREE, jalankan EXPLAIN ANALYZE dari browser
• Analitik & Window Functions — revenue time-series, top products per kategori, funnel, RFM, ringkasan GROUPING SETS
• Geospasial (earthdistance) — cari seller terdekat dari koordinat via cube/earthdistance, GiST index
• Realtime LISTEN/NOTIFY — push order baru ke browser via SSE, trigger pg_notify
• Vector Similarity (pgvector) — produk mirip via embedding cosine distance, index HNSW