Open Source — Tech News

All topics AI agents ai api architecture automation aws beginners career claude database devchallenge devops discuss javascript linux llm machinelearning mcp opensource performance productivity programming python rust security showdev tutorial typescript webdev

All EN RU

Advanced PostgreSQL: JSONB, partial indexes and partitioning

A trades table with 50 million rows. The query "which active trades for this user this month" takes 4 seconds. After applying the four techniques in t…

postgres jsonb indexation performance