On Wed, Jul 30, 2025 at 3:17 PM Richard Guo <guofengli...@gmail.com> wrote: > create table t (a int, b int, c int); > > explain (costs off) > select * from t t1 > natural join t t2 > natural join t t3 > natural join t t4 > natural join t t5 > natural join t t6 > natural join t t7 > natural join t t8 > natural join t t9 > natural join t t10 > ;
FWIW, for this query, I've observed that table_open/table_close are also called for each RTE_RELATION in build_physical_tlist(). Not sure if we should also be concerned about those calls. It's not clear to me how much performance impact an extra table_open might have, especially when the lock is already held, and the relation is likely present in the relcache. Thanks Richard
