From Datadog:
100x faster Postgres performance by changing 1 line
TL;DR: To check in a large list of values, use ANY(VALUES(...)) instead of ANY(ARRAY[...])
If this is a consistent issue, hopefully it's something Postgres can better optimize in the query planner.
No comments:
Post a Comment