Custom Software and Offshore Development | LARION

100x faster Postgres performance by changing 1 line

A simple but non-obvious one-line change (ANY(ARRAY[…]) to ANY(VALUES(…))) in a (bad) PostgreSQL 9.0 query cuts query time from 20s to 0.2s. Starting with low-level metrics we make our way to your best friend: EXPLAIN ANALYZE. The amount of time invested will pay off a hundred times over. The Postgres community is your second best friend.


Related Articles:



More interesting resources