Trying to investigate weak performance of Devart PostgreSQL Lookup component, I profiled queries generated by it. Long story short - I got the following query (object names changed but logic stays the same):

We have changed the behaviour: SSIS Lookup component now creates one IN clause instead of many OR clauses. We post here you when the corresponding build of SSIS Data Flow Components is available for download.