Searching records in postgres database?

Question

PostgreSQL

Suppose we have a list of a million id. It is necessary to make a selection from the base of the record whose id is in this list. What are the effective solutions? Beyond the obviousfindByIdIn(List<String> id)

Answer 1

1. Make another table with a million id
2. Make join and select.

Answer 2

Create somewhere separately an ARRAY type field with these IDs, and substitute it in the query
... where id = any(array_field)