ALAndrei Lepikhovindanolivo.hashnode.dev·Sep 14, 2022 · 2 min readSubquery unnesting investigationDevelopment of the correlated subquery unnesting feature in PostgreSQL (project) de-facto stopped by the problem. EXPLAIN VERBOSE SELECT * FROM a WHERE EXISTS ( SELECT * FROM b WHERE b.x IN ( SELECT c.x FROM c WHERE c.y = a.x ) ); Seq Scan on...00
ALAndrei Lepikhovindanolivo.hashnode.dev·Sep 14, 2021 · 2 min readAsymmetric partition-wise JOIN: new bugx000055ef9a0d872e in bms_equal (a=0x55ef9c48abf8, b=0x55ef9c48abf8) at bitmapset.c:126 #1 0x000055ef9a1b6079 in find_param_path_info (rel=0x55ef9c44a308, required_outer=0x55ef9c48abf8) at relnode.c:1634 #2 0x000055ef9a1aa70d in reparameterize_path_...00
