Notice that only subqueries and parameterized nested loop joins are
mentioned. The above text does not really go into the detail of which
types of subqueries can be used, but I can confirm that they must be
subqueries that can only return a scalar value. e.g WHERE x = (SELECT
y FROM ...). The
I partitioned a table "data_table" by the key "import_id" to reduce the
number of partitions to be loaded in my queries.
I used list partitions, each containing usually just one "import_id". I
used a primary key (id, import_id)
But PostgreSQL does not consider partition keys to avoid loading not
