query.sql

application/octet-stream

Filename: query.sql

Type: application/octet-stream

Part: 2

Message: Re: Making empty Bitmapsets always be NULL

-- This file only supports 8 tables case

-- The number of partitions
\set N 256

\timing on
EXPLAIN
SELECT *
FROM testtable_1_:N, testtable_2_:N, testtable_3_:N, testtable_4_:N, testtable_5_:N, testtable_6_:N, testtable_7_:N, testtable_8_:N
WHERE testtable_1_:N.x = testtable_2_:N.x AND testtable_1_:N.x = testtable_3_:N.x AND testtable_1_:N.x = testtable_4_:N.x AND testtable_1_:N.x = testtable_5_:N.x AND testtable_1_:N.x = testtable_6_:N.x AND testtable_1_:N.x = testtable_7_:N.x AND testtable_1_:N.x = testtable_8_:N.x;