Re: distribute_restrictinfo_to_rels if restrictinfo contains volatile functions

2020-07-10 Thread Zhenghua Lyu
PM To: Zhenghua Lyu Cc: pgsql-hackers@lists.postgresql.org Subject: Re: distribute_restrictinfo_to_rels if restrictinfo contains volatile functions Zhenghua Lyu writes: > The where clause is "pushed down to the x,y" because it only > references these two relations. Yea

Re: distribute_restrictinfo_to_rels if restrictinfo contains volatile functions

2020-07-10 Thread Tom Lane
Zhenghua Lyu writes: > The where clause is "pushed down to the x,y" because it only > references these two relations. Yeah. I agree that it's somewhat unprincipled, but changing it doesn't seem like a great idea. There are a lot of users out there who aren't terribly careful about mark

distribute_restrictinfo_to_rels if restrictinfo contains volatile functions

2020-07-09 Thread Zhenghua Lyu
Hi all, consider the following SQL: gpadmin=# explain (verbose, costs off) select * from t, (select a from generate_series(1, 1)a)x,