This media is not supported in your browser
VIEW IN TELEGRAM
How Postgres 17 improves IN queries
In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements.
In Postgres 17 it takes an array and eliminates the need for multiple scans.
#dba #postgress #index #db
@unixmens
In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements.
In Postgres 17 it takes an array and eliminates the need for multiple scans.
#dba #postgress #index #db
@unixmens