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
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
