PostgreSQL 对IN,EXISTS,ANY/ALL,JOIN的sql优化方案

测试环境：

postgres=# select version();
version
———————————————————————————————————
PostgreSQL 11.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39), 64-bit
(1 row)
postgres=#