TAGS /

Indexes

2 tagged articles
When an index does more harm than good: cleaning PostgreSQL waste
PostgreSQL

When an index does more harm than good: cleaning PostgreSQL waste

PostgreSQL: how to find and drop unused indexes with pg_stat_user_indexes. Real case: a table with 15 indexes, 8 of them never used.

26 May 2026 9 min
When a LIKE '%value%' Slows Everything Down: A Real PostgreSQL Optimization Case
PostgreSQL

When a LIKE '%value%' Slows Everything Down: A Real PostgreSQL Optimization Case

PostgreSQL optimization: LIKE '%value%' causes full scan. Using pg_trgm and GIN index to turn a wildcard search into a fast lookup. Real case.

6 January 2026 5 min