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:
https://www.datadoghq.com/blog/100x-faster-postgres-performance-by-changing-1-line/

 

 

More interesting resources

Introduction to AI in Software Testing