query-c.sql

application/octet-stream

Download

\set N 1024

SET enable_partitionwise_join = on;
SET enable_hashjoin TO off;
SET enable_nestloop TO off;

\timing ON
EXPLAIN (COSTS OFF)
SELECT *
FROM (prt1_:N t1 LEFT JOIN prt2_:N t2 ON t1.id = t2.id)
RIGHT JOIN prt3_:N t3 ON (t1.id = t3.id)
WHERE t3.value % 2 = 0
ORDER BY t1.id, t1.value;