I suppose so. I would just check if these tables are vacuumed often (preferably with autovacuum) otherwise the query planner might decide not to use the index d

I suppose so. I would just check if these tables are vacuumed often (preferably with autovacuum) otherwise the query planner might decide not to use the index depending on the visibility map conditions. This post explains it in more detail: https://blog.pythian.com/postgres-covering-indexes-and-the-visibility-map/ https://blog.pythian.com/postgres-covering-indexes-and-the-v...