BUG #15454: Endless lseek

The following bug has been logged on the website:

Bug reference: 15454
Logged by: Andrea Ferranti
Email address: andrea(dot)ferranti(at)wolterskluwer(dot)com
PostgreSQL version: 9.6.10
Operating system: Ubuntu 16
Description:

Dear all,
We have experienced a strange behaviour on PostgreSQL 9.6.10.

We have a series of query that move data from a table to another by using
the following logic.

create table A;
insert data into A from B;
drop B;
rename A to B;

in an operation we need to add a step to move some "remaining data" from A
to B by using the following logic:

INSERT INTO A SELECT X
FROM B DEST_TABLE JOIN (
SELECT CALC_METHOD AS S0, P_KEY AS S1, EXECUTION_NUMBER AS S2
FROM AW_001_000012_000001 SOURCE_TABLE)
SOURCE_TABLE
ON SOURCE_TABLE.S0 = DEST_TABLE.CALC_METHOD
AND SOURCE_TABLE.S1 = DEST_TABLE.KEY_DIM