On Tue, 2 Mar 2021 at 21:53, Liu, Xinyu wrote:
> *Expected Behavior
>
> Since these two queries are semantically equivalent, we were hoping that
> PostgreSQL would evaluate them in roughly the same amount of time.
> It looks to me that there is a missing optimization rule related to pushing
> th
Hello,
We have 2 TPC-H queries which fetch the same tuples but have significant query
execution time differences (22.0 times).
We are sharing a pair of TPC-H queries that exhibit this performance difference:
First query:
SELECT"orders3"."o_comment",
"orders3"."o_orderstatus",
