Re: Expression push down from Join Node to below node.

Shubhankar Anand Kulkarni writes: Hi, > As seen, the expression got pushed down to respective foreign scan, reducing > the overall query time reduced > significantly, but there is an increase in the memory footprint. That's great on the query time improvement. When you say the memory footprin

Re: Expression push down from Join Node to below node.

Can you please resolve the doubt mentioned in the below thread? Thanks &Regards Shubhankar K Zlabs-CStore Member of Technical Staff, Zoho On Mon, 26 May 2025 16:58:12 +0530 Shubhankar Anand Kulkarni wrote --- Hi Andy, Thanks for the reply. As suggested, I tried using CTE which

Re: Expression push down from Join Node to below node.

Hi Andy, Thanks for the reply. As suggested, I tried using CTE which seems to solve the case. This is the updated plan:     QUERY PLAN   

Re: Expression push down from Join Node to below node.

Shubhankar Anand Kulkarni writes: Hi, > SELECT sensitive_data1, column1 FROM benchmark_encytion AS t1 LEFT JOIN ( > SELECT aes256_cbc_decrypt( c1, '\x1234' :: > bytea, '\x5678' :: bytea ) AS column1 FROM cipher ) AS t2 ON > t1.sensitive_data1 = t2.column1; > > As you can see in the above Que