Re: Performance of Query 4 on TPC-DS Benchmark

2024-11-10 Thread Alena Rybakina
On 10.11.2024 23:16, Alena Rybakina wrote: Hi! On 10.11.2024 22:35, Ba Jinsheng wrote: Hi all, Please see this case: Query 4 on TPC-DS benchmark: with year_total as (  select c_customer_id customer_id        ,c_first_name customer_first_name        ,c_last_name customer_last_name

Re: Performance of Query 4 on TPC-DS Benchmark

2024-11-10 Thread Alena Rybakina
7;::text) AND (dyear = 2002))* *                     Rows Removed by Filter: 372956*  Planning Time: 4.529 ms  Execution Time: 3024486.695 ms (83 rows) I have noticed significant underestimation here. In addition, these nodes are executed noticeably slower in the plan, you can see it by the current time in the explain. Have you tried any tools to improve the cardinality yet, like aqo [0]? [0] https://github.com/postgrespro/aqo -- Regards, Alena Rybakina Postgres Professional