I came across this on another forum:
PG has a limit of 100 for values in
INqueries after which the index on said column is not used. For ex: a typical
SELECT ... WHERE IN (...)query on the PK will be turned into a full table scan if the IN list exceeds 100.
I wasn't able to find anything about this. Does PG have such a limit (I imagine so), and if so, what is the limit?
I know there are times where having a large subselect would be better used in a temp table, but it would be helpful to have knowledge of where the cutoff is.