If I have read-only tables in Postgres, should I index them heavily?

T1Covered by 1 source · first reported by Databricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale at 17 Jul 2024, 14:06 UTC

We often get questions about Postgres indexing strategies, and read-only (or read-heavy) tables are especially interesting. This post was actually inspired by this question on Reddit: “I have a table with about 20 columns that each have Boolean values indicating whether the row h...