Doğa
How do I choose the right composite index column order in PostgreSQL?
Build one (user_id, status, created_at DESC) index with equality columns first and the sort column last, then drop the single-column indexes it now covers.
Tag
The PostgreSQL database: index strategies, the query planner, vacuum and performance. (Page 2/2)
11 answered questions carry this tag.
Build one (user_id, status, created_at DESC) index with equality columns first and the sort column last, then drop the single-column indexes it now covers.