Does any PostgreSQL guru understand what's going on here? First query is slow with many rows, second one is much faster. My expectation was that the two were supposed to yield similar results.
https://paste.sr.ht/blob/007f4a6ba1f60216ad787a704d5b8cee701dfdd2
@emersion For public record, I haven't found great articles explaining this. //www.percona.com/blog/sql-optimizations-in-postgresql-in-vs-exists-vs-any-all-vs-join/ shows an example where a small subquery outperforms a join, although normally joins tend to be faster. (And databases often treat exactly the same a subquery and the equivalent join.)
