Sobes.tech
Middle

What is an expression index (Expression Index / Functional Index) in PostgreSQL? What are the overheads on write operations (INSERT/UPDATE) it entails and why might the planner refuse to use it if the data types in the query expression do not match?