The JusDB Database Engineering Blog

MySQL 8.0 introduced multi-valued indexes — allowing you to index individual elements of a JSON array so queries using MEMBER OF or JSON_OVERLAPS can use an index.

UUIDs as primary keys can destroy database performance. Learn why 50M rows went from 0.5ms to 2.3ms inserts, and how to fix it with hybrid approaches.

Identify bloated indexes in PostgreSQL using pgstattuple, REINDEX CONCURRENTLY, and automated monitoring

A deep dive into PostgreSQL JSONB vs JSON storage formats, GIN and B-tree indexing strategies, containment operators, and the performance characteristics that determine which to use for document storage workloads.

A production guide to PostgreSQL full-text search — building tsvector generated columns, GIN indexes, multi-column search with setweight, ts_rank scoring, websearch_to_tsquery, and comparison against Elasticsearch.

Master MySQL index data structures and optimization strategies. Learn B+ tree internals, index selection, covering indexes, and real-world performance case studies.

Build full-text search with MongoDB Atlas Search — analyzers, scoring, autocomplete, and relevance tuning

A production guide to MySQL full-text search — FULLTEXT index creation, MATCH AGAINST in natural language and boolean modes, the 50% rule, InnoDB vs MyISAM FTS, combining with B-tree indexes, and comparison against Elasticsearch.

Deep dive into advanced database indexing strategies including composite indexes, covering indexes, and partial indexes. Optimize query performance with expert indexing techniques.

MySQL 8.0 finally supports true descending indexes — eliminating the filesort that MySQL 5.7 required when sorting results in descending order. Here's how descending indexes work and when to add them.