Thomas Hamilton <thomashamilton76@xxxxxxxxx> writes: > But in our testing under the same optimization and conditions INNER JOIN is significantly outperforming IN. [ shrug... ] You haven't provided any details, so it's impossible to offer any useful advice. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance