68 rows=112 loops=1)"
"Planning Time: 0.237 ms"
"Execution Time: 62184.253 ms"
From: Vijaykumar Jain [mailto:vijaykumarjain.git...@gmail.com]
Sent: Thursday, January 6, 2022 2:53 PM
To: Avi Weinberg
Cc: Kyotaro Horiguchi ; pgsql-performa.
Subject: Re: Same query 1
.
select lnk.*
into local_1
from tbl_link lnk
where id in (select 140 as id union select 144 union select 148)
-Original Message-
From: Kyotaro Horiguchi [mailto:horikyota@gmail.com]
Sent: Thursday, January 6, 2022 11:39 AM
To: vijaykumarjain.git...@gmail.com
Cc: Avi Weinberg ;
Hi
I have postgres_fdw table called tbl_link. The source table is 2.5 GB in size
with 122 lines (some lines has 70MB bytea column, but not the ones I select in
the example)
I noticed that when I put the specific ids in the list "where id in
(140,144,148)" it works fast (few ms), but when I put
