[aforty]

When should you use IN instead of the OR operator?

Tl;dr;

Always.

[angry__panda]

This is true for Postgres. But might not be true for other databases. For example, for MySQL, in some cases OR is faster than IN operator based on our experiments.