From 100% load on 46 CPU cores to 100% load on 1 by creating two indexes. Found it in a 2 minutes thanks to pg_stat_statements! #postgres
Conversation
Replying to
90%+ of all my support tickets go like that. A "complicated" case is one involving creating an expression index.
Replying to
And you spend half the time explaining how the expression index works. The usual answer is "that works"?