📰00Advanced PostgreSQL: JSONB, partial indexes and partitioningDEV Community·Odilon HUGONNOT·about 1 month ago#r8Psl1sR#jsonb#postgres#indexation#index#trades#fullscreen+3 more🧰Tag tools✨Add tagA 50-million-row trades table, a 4-second query. After JSONB, partial indexes and date partitioning: 12ms. The four techniques that actually move the needle in production.15s0Read later0Read More
