Elektrine lite

← Feed

@noctarius2k@mastodon.online

2026-03-17 16:44 UTC

Solving slow queries often involves adding another index. But overindexing is real and a lesser-known #Postgres feature is better: π‘ͺ𝑹𝑬𝑨𝑻𝑬 𝑺𝑻𝑨𝑻𝑰𝑺𝑻𝑰π‘ͺ𝑺 πŸ’‘ I often tried to solve a slow query or bad execution plan by adding another, more specific index. It works but ... damn it was expensive. A lesser-known feature in Postgres is extended statistics. Something, everybody should know about when using PG. https://vela.simplyblock.io/blog/postgres-create-extended-statistics/

Replies (0)

No replies.