in reply to PSQL and many queries

citycrew:

I'd suggest using your databases bulk-loading tool, and load the names from the file into a table, then use an SQL statement to do the heavy lifting. Bulk loading is typically the fastest way to get the data into the database, and then you can add a key to the table and then join the tables to do your filtering for you. Doing a record-by-record sequence can be painfully slow because of all the communications overhead.

...roboticus