你问的PG.我贴一个SQL Server的供参考

https://www.jianshu.com/p/840adac0f56a

PG的有吗？各位大佬

好像大表大范围建议使用exists，固定值用in比较好；

https://blog.csdn.net/weixin_39540651/article/details/104990653?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522163377168016780255229705%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fblog.%2522%257D&request_id=163377168016780255229705&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~blog~first_rank_v2~rank_v29-1-104990653.pc_v2_rank_blog_default&utm_term=exis&spm=1018.2226.3001.4450