#indexing Articles - NextGenBeing

AI Tutorials 9 min read

PostgreSQL Partial Index vs BRIN vs Expression Index: Measured on 3M Rows

Reproducible benchmarks of a PostgreSQL partial index, BRIN index, expression index and INCLUDE index on 3M rows, with sizes, plans and when each does nothing.

#PostgreSQL #Performance #SQL

Apr 19, 2026

Database Indexing vs Caching: Measure First, Then Decide

Measure Postgres composite, covering and partial indexes with EXPLAIN ANALYZE in Docker, then test Redis cache-aside, with a rule for database indexing vs caching.

#Redis #Performance #Caching

Apr 18, 2026

Database Optimization Techniques for High-Traffic Websites

Learn how to optimize your database for high-traffic websites with techniques such as indexing, caching, and query optimization. Improve performance and scalability with these expert tips and best pr…

#Performance #Caching #scalability

Mar 04, 2026